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
|