Series Numbering for Duplicate Entries?

[deekay247]

Hello everyone!

I have two columns, A and B. In column B I have 4527 rows filled with
single and duplicate names. In column A I would like to number them in
series so that it would follow the duplicates and single entries in
column B.

Column A | Column B
________________________________
1| 212
1| 212
1| 212
2| 212 ON ICE GREEN
3| 212 WHITE
4| 273 INDIGO
4| 273 INDIGO
5| ACQUA DI GIO
5| ACQUA DI GIO

Thanks, David

 

[Ardus Petus]

Insert an empty row before first row of data

In A2, enter;
=IF(B2=B1,A1,A1+1)
and copy down in column A

see example: http://cjoint.com/?dyjksc52T1

HTH
--
AP

"deekay247" <[email protected]> a écrit
dans le message de
news:[email protected]...