Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out duplicates while ignoring 1 row
I am trying to filter a range of data for duplicates but ignoring 1 column of
data. I do not want that column to be consiered when filtering out duplicates (if the column is considered none of the rows are considered duplicate) but I still want that data available for the rows that are left after the filter. I tried leaving that column out when I set criteria range in the advanced filter, but that didn't seem to work. Any other ideas? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting values ignoring duplicates | Excel Worksheet Functions | |||
Counting Names in a Column, Ignoring Duplicates | Excel Discussion (Misc queries) | |||
Filtering Duplicates | Excel Discussion (Misc queries) | |||
Filtering a list with duplicates | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |