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.