Select the range
Menu DataFilter?Advanced Filter...
Tick the 'Unique records only' box
Define the criteria
Click the 'Filter in place' or 'Copy to another location' button
OK
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Elizabeth" wrote in message
...
I am trying to filter out a unique set of records in a Excel worksheet. I
think Advanced Filter is what I need to use but I can't figure it out.
Please help.
|