ExcelBanter - numbering based on new values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - numbering based on new values (https://www.excelbanter.com/excel-discussion-misc-queries/225040-numbering-based-new-values.html)

Cindy E

numbering based on new values

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

Gary''s Student

numbering based on new values

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

All times are GMT +1. The time now is 04:34 AM.