| Posted: October 29, 2009, 3:57 pm - IP Logged | |
Steve,
Formula
=IF(SUM(ISNUMBER(MATCH(MID(A289,{1,2,3},1)+0,{5,6,7,8,9},0))+0)>1,1,2)&IF(SUM((MOD(MID(A289,{1,2,3},1)+0,2)=0)+0)>1,1,2)&IF(SUM(ISNUMBER(MATCH(MID(A289,{1,2,3},1)+0,{3,4,5,6,7},0))+0)>1,1,2)&IF(SUM(ISNUMBER(MATCH(ABS(MID(A289,{1,1,2},1)-MID(A289,{2,3,3},1)),{1,9},0))+0),1,2)