Random Numbers in one function

[tahasiddique]

Hello all,

I'm currently working on my masters dissertation and am using excel 2010.

Basically, I'm trying to generate a list of say, 1000 numbers within a range. I can already do this using the rand() function. However, I need excel to take each random number, apply it into a formula, and then list the answers in a seperate location. This would be easy to do if there was one simple function (which i could just insert into any adjacent cell). The problem is that each random number value is input into a table. The table, which has about 10 columns and 200+ rows, gives one final answer.

I'm sure there has to be a faster way than creating 1000 tables for each random number generated.

Let's say I have a list of 1000 random numbers in sheet 1. the function table is in sheet 2 and produces the answer in the same sheet, in a single cell. I'd like excel to use each random number generated, input it into the function table, attain the answer from the table, and list it in the cell next to the random number.

Any help would be greatly appreciated.

Thank you,
Taha.

posted here also:
http://www.ozgrid.com/forum/showthread.php?t=167893

and

http://www.mrexcel.com/forum/showthr...n-one-function

[martindwilson]

cross post at
http://www.mrexcel.com/forum/showthr...n-one-function
http://www.ozgrid.com/forum/showthread.php?t=167893

[Cutter]

Thanks MDW

Hello tahasiddique, and welcome to the forum. Unfortunately you have inadvertently broken one of the forum rules. Rule #8 requires that you provide links to other forums where you ask the same question. Please read the rule (and the reason for the rule) below. Thanks.

Rule 8: Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[tahasiddique]

I have editted my original post.

I'm sorry for cross posting.

Taha.

[shg]

Excel has a built-in capability to do this called a data table. See http://office.microsoft.com/en-us/ex...010072656.aspx

[tahasiddique]

HI SHG,

I tried the data set and scenario options in excel however i dont think they allow me to view all possible results at the same time. scenarios might work however each scenario can only be viewed once. I need to be able to input 1000 values and attain 1000 values from the table simultaneously.

thanks for your help!
Taha.

[shg]

Not scenarios, data tables. Did you look at the link?

To my knowledge, there is no restriction other than memory on the size of a data table.