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

  • Thread starter Thread starter JenIT
  • Start date Start date
J

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.
 
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
 
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
 
Back
Top