View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default counting the number of times shown

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

--
Gary''s Student - gsnu201001


"klh84" wrote:

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