DataFilterAdvanced Filter.

Unique records and Copy to another place.

If you want to copy to another worksheet, see Debra Dalgleish's site for more
info.

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 09:10:21 -0500, 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. :-)