removing and inserting duplicate names

[Guest]

i need to sort out duplicate names and dates from spreadsheets. i am working
with names and dates daily and sometimes there are names that were not on the
log i received one day but show up at a later date.is there a way to do
this???

 

[Gord Dibben]

gerrior

For starters........

You can do this with Advanced Filter and "unique records only" and "copy to
another location".

For more on this see instructions and graphics at Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP