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




On Aug 24, 1:19*pm, JenIT <jen...@alliedstaffing.com> wrote:
> 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.

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