Quote:
Originally Posted by xor
Why not 1 1 2 2 2 3 (total 11) from the first row?
If I am right then that's exactly what my formula in #4 does.
=SUMPRODUCT(SMALL(A1:K1,COLUMN($A:$F)))
|
I want the formula to randomly select any six small numbers on a row
Without arrange them. From the table above the ones 1 1 2 2 2 3 which is (11)
But from your formula $A:$F
Meaning from A to F but I want excel to check A to K and select any six small numbers and add them