Is it possible to filter for 3 arrays, each array relating to a separate column.
The net filter would be the intersection of the 3 criteria.
Please Login or Register to view this content.
Is it possible to filter for 3 arrays, each array relating to a separate column.
The net filter would be the intersection of the 3 criteria.
Please Login or Register to view this content.
Thanks, the sample is attached.
Before:
After:Please Login or Register to view this content.
Please Login or Register to view this content.
Not clear to me.
What should happen when you change Array_3 to Array(101, 103) instead of 102?
Anyway the elements of the array used for the criteria in autofilter need to be String, so it should be like
Please Login or Register to view this content.
Thanks for advising.
For filtering as follows.
Output should be:Please Login or Register to view this content.
So the intersection, common for all three arrays.Please Login or Register to view this content.
Try change to
Please Login or Register to view this content.
Thanks jindon, that's a good solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks