[b]PLEASE HELP ME[/b]

[mandyweems]

I have a huge data base and i need to cut out all of the duplicates i have been told that it is called a "perge" but i have know idea what i am doing

PLEASE HELP

 

[Oaktree]

Welcome to the board.

If you're trying to de-dup column A,

1) Select column A
2) go to data --> filter --> advanced filter.
3) Select "copy to another location", enter B1 or other location for the top most entry, check the "unique records only" box, and click OK.

 

[Von Pookie]

Duplicate post. Please stay to one thread on the same topic:
http://www.mrexcel.com/board2/viewtopic.php?t=127293