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
+-------------------------------------------------------------------

--
jinvicto
-----------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...fo&userid=3409
View this thread: http://www.excelforum.com/showthread.php?threadid=55399

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" wrote
in message ...

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


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

--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile:
http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=553993

file reattached
thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=553993

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.


---
Regards,
Norman



"jinvictor" wrote
in message ...

file reattached
thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile:
http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=553993

=sum(a1+b1)


--
kartune85
------------------------------------------------------------------------
kartune85's Profile: http://www.excelforum.com/member.php...o&userid=35586
View this thread: http://www.excelforum.com/showthread...hreadid=553993

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

Cheers
--
AP

"kartune85" a écrit
dans le message de news:
...

=sum(a1+b1)


--
kartune85
------------------------------------------------------------------------
kartune85's Profile:
http://www.excelforum.com/member.php...o&userid=35586
View this thread: http://www.excelforum.com/showthread...hreadid=553993

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)