Every cell in Column A starting in row 2 is filled with seven digit numbers.
Often times each seven digit number will occur more than once. I want to
create a macro that covers every cell in Columns A:B starting in row 2 so
that if I have a seven digit number that appears for the first time in cell
A5 a €œ1€� will appear next to it in B5. If that same seven digit number
appears again by chance in cell A25 a €œ2€� will appear next to it in cell B25.
Finally if that same seven digit number appears by chance in cell A39 then a
€œ3€� will appear next to it in cell B39.