You could try an advanced filter...

Sort your records by name, then highlight only the name column. Then
Data/Filter/Advanced Filter. Check the "Unique Records Only" box, and hit OK.
You should now see that only one row per name is available. From here I would
highlight the entire data range, select visible cells only (shortcut to this
is highlighting the data range, hit F5, Special, Visible Cells Only) and then
I would copy and paste them onto a new sheet.

Cheers,

Mike

"NNothard" wrote:


Hi,

Does anyone know if there is a way to delete duplicate values in list
of names. I have a spreadsheet with about 10 000 records but each
person is reprasented several times in the list. I would like to simply
delete any duplicates, but going through the list deleting row by row is
just driving me mad. :-)


--
NNothard
------------------------------------------------------------------------
NNothard's Profile: http://www.excelforum.com/member.php...o&userid=35791
View this thread: http://www.excelforum.com/showthread...hreadid=555580