need help with Advanced filter.

E

Elizabeth

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.
 
B

Bob Phillips

Select the range
Menu Data>Filter?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)
 
Top