Counting Formula

M

MCheru

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?
 
T

T. Valko

Every cell in Column A starting in row 2 is filled

You can try this but if the above is literally true, this may not be such a
good idea!

Entered in B2 and copied down as needed.

=COUNTIF(A$2:A2,A2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Macro 8
assign occurence number 3
Source and Destination 1
counting digits, not numbers 4
Two Criteria = 1 6
Help with a multi if then else formula. 5
numbers convert to formula in csv 1
Summing every 7 cells consecutively 4

Top