On Nov 30, 10:44*pm, "Jim Cone" wrote:
As to the use of the Shift key...
I thought you were referring to the XL Companion add-in of mine that I included in the list of possible solutions.
'--
Try sorting your data in descending order and then using the built-in xl2007 Remove Duplicates utility.
--
Jim Cone
Portland, Oregon *USAhttp://www.mediafire.com/PrimitiveSoftware

.
.
.

"robzrob"
wrote in ...
On Nov 28, 2:45 pm, "Jim Cone" wrote:

XL Companion...
"Thx. 'Remove duplicates' worked.- Hmm - no it didn't - it removed the duplicates, but left me with the first row not the last :("

Pressing the Shift key when clicking OK reverses the removal order - it leaves the last "duplicate" row.
--
Jim Cone
Portland, Oregon USAhttp://www.mediafire.com/PrimitiveSoftware

That's not working - I'm still left with the first.

"Try sorting your data in descending order and then using the built-in
xl2007 Remove Duplicates utility." Tried that - even though they're
sorted DEscending, it still takes out the latest lines and I'm left
with the first!! It's a b****r, innit? :)