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
|