counting the number an item appears
 

I am trying to place a number next to an item for every time it appears, any
suggestions?

ex:
apple 1
orange 1
grape 1
apple 2
apple 3
orange 2
kiwi 1

counting the number an item appears
 

Assuming your data starts in cell A1, enter this formula in B1 and copy down
as needed:

=COUNTIF(A$1:A1,A1)

--
Biff
Microsoft Excel MVP


"klh84" wrote in message
...
I am trying to place a number next to an item for every time it appears,
any
suggestions?

ex:
apple 1
orange 1
grape 1
apple 2
apple 3
orange 2
kiwi 1

counting the number an item appears
 

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 place a number next to an item for every time it appears, any
suggestions?

ex:
apple 1
orange 1
grape 1
apple 2
apple 3
orange 2
kiwi 1

counting the number an item appears
 

Put this in B1:

=COUNTIF(A$1:A1,A1)

and copy down.

Hope this helps.

Pete

On Feb 25, 6:53*pm, klh84 wrote:
I am trying to place a number next to an item for every time it appears, any
suggestions?

ex:
apple * * 1
orange * 1
grape * * 1
apple * * 2
apple * * 3
orange * 2
kiwi * * * 1