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
|