Counting Formula
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
put a formula in every cell in Column 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 in cell A25
a 2 will appear next to it in cell B25. Finally if that same number
appears in cell A39 then a 3 will appear next to it in cell B39. However
the numbers won't always appear in A5, B25, or B39. Those were random cells
that I selected. Is this possible or do I need a macro to do this?
|