merlin_the_magician
Active Member
- Joined
- Jul 31, 2002
- Messages
- 480
I have a workbook in which i would like to perform an autofilter.
Column "o" contains somewhat 1500 rows with critical search data, exsisting of numbers being eighter 0, 1, 2, 3 or 4. These numbers however are not always there, since the represent a certain event.
If there is no number, a text "not available" appears.
Question: How do i autofilter all data that is NOT "not available"? Autofilter offers only 2 search strings, so searching for 0,1,2,3,4 is not possible, so i will need some kind of "reverse autofilter"
Column "o" contains somewhat 1500 rows with critical search data, exsisting of numbers being eighter 0, 1, 2, 3 or 4. These numbers however are not always there, since the represent a certain event.
If there is no number, a text "not available" appears.
Question: How do i autofilter all data that is NOT "not available"? Autofilter offers only 2 search strings, so searching for 0,1,2,3,4 is not possible, so i will need some kind of "reverse autofilter"