you could use advanced filter. select your data and click
data/filter/advanced filter, copy to another location, select a cell in an
empty column for your copy to range, and click the unique records only
checkbox.

if you're using XL2007, I'm not sure how to access the advanced filter. But
it should be there somewhere.


"red14red" wrote:

Anybody out there that can give me a hand with this? I have a large amount of
data with duplicates. Need to be able to delete the dups without having to
manually do so. Thanks in advance.