All even numbers from 1 to 80

  • Thread starter Thread starter Rakesh
  • Start date Start date
R

Rakesh

From 1 to 80 I have to choose any 10 numbers based on two
conditions.

The first condition is that all the 10 numbers should
be "even" numbers.

The second condition is that out of those 10 (even)
numbers, 5 numbers should be between 1 to 40 and 5 numbers
should be between 41 to 80.

How to get all the possible combinations based on (both)
the conditions and how many combinations will I get?
 
Hi
is this homework / coursework??
Or for what do you need this calculations :-)

And similar to your previous question:
many combinations (somethere in the range 4E+6) but due to your
conditions not that many (You would be able to put them on one
worksheet - one cell per combination)
 
Hi Rakesh!

I'm assuming random numbers between 1 and 80 *without* replacement.

Column A
A1
=ROW()
Copied down to A80
Copy > Edit > Paste Special > Values > OK

Column B
B1
=RAND()
Copied down to B80
Copy > Edit > Paste Special > Values > OK

Column C
C1
=ISEVEN(A1)
Copied down to C80

Sort in two batches of row 1-40 and 41-80 based on the random number column
Sort on TRUE and FALSE in the two batches and take the first five TRUE in
each batch



--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top