(formula in cell L1) =IF(B1 =0,IF(B1 =10,B1, ), )

(formula in cell M1) =IF(C1 =0,IF(C1 =10,C1, ), )

(formula in cell U1) =IF(A1 10,IF(A1 =20,A1, ), )

(formula in cell V1) =IF(B1 10,IF(B1 =20,B1, ), )

(formula in cell W1) =IF(C1 10,IF(C1 =20,C1, ), )

Put in the K1 and U1 cell formulas, you may be able to drag-and-drop.]]>

The lowest number from the group 1 to 10, whatever it is, should appear in cell K1. Not easy :-S

Anyone else]]>

In cell AE1 - =Countif(A1:J1,1)

This looks at the A1 - J1 array and counts the number of times 1 shows up.

then

In cells K1 - =If(AE1 0,1,0)

If one does appear in the array then it puts the value of 1 in K1 - otherwise it puts in zero.

For a second example I'll do 7

In cell AK1 - =countif(a1:j1,7)

In cell Q1 - =If(AK1]]>

I wonder if anyone can help me with this excel question.

In cells A1 to J1, I have 10 numbers:

A1 B1 C1 D1 E1 F1 G1 H1 I1 J1

1 7 11 14 18 19 22 27 39 40

In cells K1 - T1, I would like to appear the numbers from 1-10 (so in this example: 1 in cell K1, and 7 in cell L1, cells M1 to T1 remain blank).

In cells U1 - AD1, I would like to appear the numbers form 11-20 (so in this example: 11 in cell U1, 14 in cell V1, 18 in cell W1 and 19 in cell X1, cells Y1 to A... [ More ]]]>