count duplicats, display incremental count, restart count at changein value

[JenIT]

I hope my subject was not too confusing. I have a sheet with values
like this in col A: Col B is currently blank but this is what I want
in it...

A B
apple 1
apple 2
orange 1
orange 2
orange 3
orange 4
pear 1
pear 2

Add and incremental counter for same values in column A - display
count. At change in value of A - restart count. I'm sure there is
something like this out there but not sure how to search for it and
was unable to find something that would help me.

 

[DCG-jaeson]

Hi JEN,

Use this formula in Column B2, then paste B3 to as you like;

=IF(A2=A1,1+B1,1)

Just Put some Header in Column A1 as "FRUIT NAME" and B1 as "COUNT",
for the formula wont have a error.

Hope this will help,
~jaeson

 

[JenIT]

Awesome!! Thanks Jaeson that did the trick and easy too!

Thanks to you and all the others who answer questions on this group.
I have gotten a lot of help from the experts in the group! Thanks for
a great resource!!!

Great day to all,
Jen