I thought it would be easy to run the Macro recorder.
First record a Sort. Then record the AdvancedFilter on Unique items.
Triggered both Macros by a Worksheet Change event.
Problems:
1. Sort Only works with a 1 (number or text) in the first position - under INPUT (B5:B16)
2. FilterUnique don't filter the above 1, leaving two 1's - under OUTPUT (C5)
What am I missing?
Ola
Example file attached
Please Login or Register to view this content.
Bookmarks