Need to add Sequence/Instance Number to Duplicate Records

  • Thread starter Thread starter mcmilja
  • Start date Start date
M

mcmilja

Hello,

How would I go about adding a Sequence/Instance Number to Duplicate Records?

Example: I have a list of duplicate site names and I want the 1st instance
to be "1" and the 2nd instance to be "2".

Site | Seq/Inst Num
ABBEVILLE | 1
ABBEVILLE | 2
AIRPORT MEMPHIS | 1
AIRPORT MEMPHIS | 2
AIRPORT NASHVILLE | 1
AIRPORT NASHVILLE | 2

Thanks!
Jaret
 
Try this in cell B2, then copy down as far as your data goes.

=COUNTIF($A$2:A2,A2)

HTH
Elkar
 
Back
Top