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?

Counting Formula
 

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)

--
Biff
Microsoft Excel MVP


"MCheru" wrote in message
...
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?

Counting Formula
 

Sorry for the delay. This is very good. Thank you for you're help!

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"MCheru" wrote in message
...
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?

Counting Formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"MCheru" wrote in message
...
Sorry for the delay. This is very good. Thank you for you're help!

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"MCheru" wrote in message
...
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?