counting the number of times shown

[klh84]

I am trying to figure out a way to put a numerical value next to the id that
is shown, suggestions?

ex:
ID This is what I am hoping to get to show up in the next column
55 1
55 2
37 1
46 1
62 1
55 3
89 1
82 1

 

[Per Jessen]

Hi

With ID in column A, insert this formula in B2 and copy it down as required:

=COUNTIF($A$2:A2,A2)

Regards,
Per

 

[Mike H]

Hi,

Assuming your data starts in a2 try this in B2 and drag down

=COUNTIF($A$2:A2,A2)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Gary''s Student]

In B1 enter: 1
in B2 enter: =COUNTIF($A$1:$A2,A2) and copy down