In my worksheet I have a list of Racehorses sorted in alphabetical order
Column A

Acambo (GER) A
Accordello a
According To John a
Acropolis (IRE) C
Admiral (IRE) B
Afsoun (FR) D
AI Elle (IRE) B E
Air Force One (GER) D
Akarem A
Akllak (IRE) b E
Albert Mooney (IRE) A C


The Letters are in sucessive columns and refer to forthcoming races ( e.g.
€œC€� is the Derby ). Each week I update with a new race by scanning from the
racing paper, and then copy paste in to the bottom of the worksheet. I then
enter the next letter for the race in question in the next available column
and then sort. This inevitably produces duplicate horses with the new entry.
How do I delete the duplicate horse but keep the new entry in the same row
as the other entries for that particular horse???? At the moment I am having
to go through the list deleting the duplicates and at the same time moving
the entry race in to the original row.

I look forward to hearing from you

Best

Brian