Counting Macro
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.
|