How can I find duplicate entries in an entire worksheet?

[jbrown]

I have pulled in information from a database and I am trying to remove
duplicate records without having to look manually. Is there a way to do this?

[MartinShort]

Advanced Filter will do this for you. Copy your selection to another location making sure you check the Unique Records only flag.

[JE McGimpsey]

Take a look at

http://cpearson.com/excel/duplicat.htm


In article <[email protected]>,
jbrown <[email protected]> wrote:

> I have pulled in information from a database and I am trying to remove
> duplicate records without having to look manually. Is there a way to do this?

[CLR]

ASAP Utilities has a feature that does this nicely...........

Free at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3




"jbrown" <[email protected]> wrote in message
news:[email protected]...
> I have pulled in information from a database and I am trying to remove
> duplicate records without having to look manually. Is there a way to do
this?