J
jinvictor
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)
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)
