Chihiro
Excel Ninja
Thread below got me thinking today.
http://chandoo.org/forum/threads/ho...es-not-equal-to’-filter-in-same-column.30476/
As mentioned in the thread, there's no direct way using Autofilter to exclude more than 2 values. And while putting values to be displayed in array works, it's cumbersome when working with large data.
Attached is sample using UserForm and listbox to quickly select values you want to exclude from filter result.
It's not optimized yet, but does what I originally set out to do.
1. Populate listbox with unique values from column on a sheet (currently Sheet1, column A) which contains duplicate values
2. Sort unique values alphabetically without altering worksheet
3. Use 2 listbox to set filter inclusion and exclusion list (Items listed in left box will be displayed, items in right box will be filtered out)
Reference:
For sort method using ArrayList from .Net: see post by jindon
http://www.ozgrid.com/forum/showthread.php?t=181769
http://chandoo.org/forum/threads/ho...es-not-equal-to’-filter-in-same-column.30476/
As mentioned in the thread, there's no direct way using Autofilter to exclude more than 2 values. And while putting values to be displayed in array works, it's cumbersome when working with large data.
Attached is sample using UserForm and listbox to quickly select values you want to exclude from filter result.
It's not optimized yet, but does what I originally set out to do.
1. Populate listbox with unique values from column on a sheet (currently Sheet1, column A) which contains duplicate values
2. Sort unique values alphabetically without altering worksheet
3. Use 2 listbox to set filter inclusion and exclusion list (Items listed in left box will be displayed, items in right box will be filtered out)
Reference:
For sort method using ArrayList from .Net: see post by jindon
http://www.ozgrid.com/forum/showthread.php?t=181769