Filtering

Should that read A250? Excel likes when you have 1 data point (you have 6) in each cell. I think this will require a VBA solution (or a lot of helper columns).

Originally Posted by ChemistB

Should that read A250? Excel likes when you have 1 data point (you have 6) in each cell. I think this will require a VBA solution (or a lot of helper columns).

I have 250 rows in each column A - M and yes each has a set of six digits separated by a ,

Am I correct in thinking you say it would be better to do say 13 sheets and split each entry into one number per cell? so they would be a-f in each of the 250 rows on all 13 sheets if so is there an easy way to change the data into that way than manually re entering it?

Here's an example of finding >3 odd, >3 Even and more than 2 consecutive #'s. Can you clarify on your last criteria?

Copy each column to a fresh sheet and then do "Text to Columns">Delimited>check off comma and ENTER. That moves them to their own cells.

Formula's in attached sheet
>3 Odd =SUMPRODUCT(--(MOD($A2:$F2,2)=1))>3
>3 Even =SUMPRODUCT(--(MOD($A2:$F2,2)=0))>3
>2 Conseq =SUMPRODUCT(--(B2:E2-A2:D2=1),--(C2:F2-B2:E2=1))>0

PS. I won't be around till monday so maybe someone else can help you.

post a workbook with samples and expected results

ChemistB < Admittedly stumped. (but working on it)
Based on your first post;
1. numbers can range from 1 into the thousands
2. they may or may not be in order
True?

where is the example i asked for?