counting the number of times shown
 

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

counting the number of times shown
 

Hi

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

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

Regards,
Per

"klh84" skrev i meddelelsen
...
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

counting the number of times shown
 

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.


"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

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