View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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