Prev: between function?
Next: Label filter disabled
From: klh84 on 25 Feb 2010 13:53
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
From: T. Valko on 25 Feb 2010 14:01
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" <klh84(a)discussions.microsoft.com> wrote in message
news:48F067A2-BC8F-4DE2-A1BF-C8F0F5550A25(a)microsoft.com...
>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


From: Gary''s Student on 25 Feb 2010 14:03
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
From: Pete_UK on 25 Feb 2010 14:06
Put this in B1:

=COUNTIF(A$1:A1,A1)

and copy down.

Hope this helps.

Pete

On Feb 25, 6:53 pm, klh84 <kl...(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: between function?
Next: Label filter disabled