Adavanced Filter/ Unique records only, then sort.
--
David Biddulph

"spreadsheet monkey" wrote in
message ...
hi,

I have a list of n number of values (i.e names and ID numbers). each
unique
value will have several entries (i.e the same ID number and name will
exist
multiple times)
I want to sort the data so that the remains will be a single entry per
unique value (i.e every name only pops up once)

how do I do it?