Need a function that samples without replacement
X xQQSme Oct 22, 2003 #2 If B is Exel's error msg. sample error (ISNA) Suppose in A1 is the number 10 In B1 =0+LEFT(A1,MATCH(FALSE,ISNUMBER(1*MID(A1,ROW(INDIRECT ("1:"&LEN(A1))),1)),0)-1) In C1 =IF(AND(ISNUMBER(A1),ISNA(B1)),"Your Text","") HTH
If B is Exel's error msg. sample error (ISNA) Suppose in A1 is the number 10 In B1 =0+LEFT(A1,MATCH(FALSE,ISNUMBER(1*MID(A1,ROW(INDIRECT ("1:"&LEN(A1))),1)),0)-1) In C1 =IF(AND(ISNUMBER(A1),ISNA(B1)),"Your Text","") HTH
