Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering without redundancies
I am trying to run a filter based on a certain column and need each value
represented only once. When I make a custom filter and check the unique entries only, it doesn't do anything to the column. When I run an AutoFilter it works but shows every instance for that value. Am I missing something? -- RedFive |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering without redundancies
I'd add an extra column with a formula like:
=countif(a$2:a2,a2) Then I'd filter on this column first to show the 1's. RedFive wrote: I am trying to run a filter based on a certain column and need each value represented only once. When I make a custom filter and check the unique entries only, it doesn't do anything to the column. When I run an AutoFilter it works but shows every instance for that value. Am I missing something? -- RedFive -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering without redundancies
You can use AdvanceFilter but you have to selct only one column of data and
if you copy the data it has to be on the same owrksheet. Try from worksheet menu Data - filters - AdvanceFilter and check unique. You can record a macro while manually performing the Advance Filter to get the code for a macro. "RedFive" wrote: I am trying to run a filter based on a certain column and need each value represented only once. When I make a custom filter and check the unique entries only, it doesn't do anything to the column. When I run an AutoFilter it works but shows every instance for that value. Am I missing something? -- RedFive |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering | New Users to Excel | |||
Filtering | Excel Discussion (Misc queries) | |||
Filtering | Excel Worksheet Functions | |||
Filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |