Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help!
1. we have about 130 people all together, I want the fomula can divide them to 3 or 4 different groups and automaticlyfill their name in different sheets. EXAMPLE: sheet 1, a1:a130 (130 names) sheet 2, a3:a33 (30 names), a35:a64(30 names) 2. After the first step, I want draw numbers, its random number between 1-13,and the drawed number can be the same no in b2. EXAMPLE: b2: 1 number(not random), b3:b33 random numbers between 1-13, but number can't be same as in b2. 3. After 26 rounds, I want all score add up by names and sorted from biggest to smallest with no and name in "running score" sheet. EXAMPLE: sheet 3, a2: id no, name, total score(biggist) a3: id no, name, total score(second) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help!
This is very hard to understand -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=555159 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|