I would like to compare 6 digit data stored in six columns with a string of data.
The input digits range 1 to 49.
Then matched numbers are then displayed in one column and the number of
digits match in the next.
Any solution which could produce the expected results will be fine with me.
Please see attached excel 2007 file for the details.