counting the number of times shown

  • Thread starter Thread starter klh84
  • Start date Start date
K

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
 
Hi

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

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

Regards,
Per
 
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.
 
Back
Top