randomization in excel

[kai shing yu]

Hello. I have an excel file with 30 sheets. Each sheet has 4 column and
120 rows.
I would like to randomly select 100 numbers from this file.
How can I do this?
Thanks for your kindly and sincerely help!

*** Sent via Developersdex http://www.developersdex.com ***

 

[Mike Middleton]

kai shing yu -

Others will answer "How."

I'm more interested in "Why."

That is, what it that you are going to do with the 100 numbers instead of
doing it with the entire 30*4*120 = 14400 numbers?

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel