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