Need to add Sequence/Instance Number to Duplicate Records
 

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

Need to add Sequence/Instance Number to Duplicate Records
 

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

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

HTH
Elkar


"mcmilja" wrote:

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

Need to add Sequence/Instance Number to Duplicate Records
 

=A2&"|"&COUNTIF($A$2:$A2,A2)

and copy down

--
__________________________________
HTH

Bob

"mcmilja" wrote in message
...
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

Need to add Sequence/Instance Number to Duplicate Records
 

Thanks Elkar!

"Elkar" wrote:

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

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

HTH
Elkar


"mcmilja" wrote:

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