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 |
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 |
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 |
All times are GMT +1. The time now is 01:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com