please help, ned urgent

[jinvictor]

its not a vba problem, i just want use fomula to get this down
informations inside the file. than

+-------------------------------------------------------------------
|Filename: sample.zip
|Download: http://www.excelforum.com/attachment.php?postid=4918
+-------------------------------------------------------------------

 

[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)

 

[jinvictor]

file reattached
thanx

 

[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.

 

[kartune85]

=sum(a1+b1)

 

[Ardus Petus]

The SUM part is overkill
why not:
=A1+B1
or:
=SUM(A1:B1)

Cheers

 

[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)