| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions | |||
| Advanced Filter Problems | Excel Discussion (Misc queries) | |||
| Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
| Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
