I have a list of data that I want to filter using the Autofilter command.
One column contains numbers from 1-96. I want to filter out all numbers apart from those beginning with 1 and then moving up in increments of 4, i.e. 1, 5, 9, 13, 17, 21, etc.
If I go to the custom autofilter, I can put "equals" 1 AND "equals" 5, but obviously I can't go any further as I can only put 2 conditions in.
Is there any way of doing this? Something along the lines of:
"equals" 1 OR 5 OR 9 OR 13 OR 17 OR 21 ......etc.?
One column contains numbers from 1-96. I want to filter out all numbers apart from those beginning with 1 and then moving up in increments of 4, i.e. 1, 5, 9, 13, 17, 21, etc.
If I go to the custom autofilter, I can put "equals" 1 AND "equals" 5, but obviously I can't go any further as I can only put 2 conditions in.
Is there any way of doing this? Something along the lines of:
"equals" 1 OR 5 OR 9 OR 13 OR 17 OR 21 ......etc.?