need help with Advanced filter.
 

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.

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.