iaudio1233
Board Regular
- Joined
- Mar 7, 2014
- Messages
- 158
Hi,
there are 12 numbers from 1 to 12
there are 12 cells
requirement : choose 1 number from 1 to 12 and not appear again in any of the other 11 cells
eg.
a1 8
a2 12
a3 7
a4 5
a5 3
a6 11
a7 2
a8 9
a9 8
a10 1
a11 5
a12 4
kindly advise what function should be used ?
thanks
there are 12 numbers from 1 to 12
there are 12 cells
requirement : choose 1 number from 1 to 12 and not appear again in any of the other 11 cells
eg.
a1 8
a2 12
a3 7
a4 5
a5 3
a6 11
a7 2
a8 9
a9 8
a10 1
a11 5
a12 4
kindly advise what function should be used ?
thanks