I would be so happy if you could help me with filtering.
I have 250 rows in each column A - M and yes each has a set of six digits separated by a ,
I have starting at A1 to N250 data, all numeric containing 6 numbers (i.e. 1,2,3,4,5,6 - 25,96,113,78,5914,27) and with these I wish to filter them as follows:
any with 4,5 or 6 odd or even numbers
any with more than two consecutive numbers
any with more than two within a range of 10
If needed I can put them all on 13 sheets and with help have one set of six numbers per row as I do not know how to swap them over. also as they all relate to different aspects I could not place them all in A column so would need to keep column's seperate.
Thank you in advance for your help.
Bookmarks