In C1 enter 1
In C2 enter:
=IF(A2=A1,C1+1,1) and copy down
--
Gary''s Student - gsnu200840


"Cindy E" wrote:

I have a spreasheet with items by dealer--some have 1 item, some have 2 or
more. Each item is a separate row. I need to renumber the items by each
dealer like below:

joe book 1
joe cap 2
joe car 3
tom book 1
jill car 1
jill book 2

any help is greatly appreciated.

Thanks