please help, ned urgent

B

Bob Phillips

You might try telling us a bit about it, and what you want, we are not
mind-readers.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
N

Norman Jones

Hi Jinvictor,

Few in this newsgroup would be prepared to open an unknown attachment.

As Bob suggested, why not explain your requirements in a simple word (not
Word!) format.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top