Quote:
Originally Posted by CONN CHRIS
I just want to be able to keep it open and re-calculate as often as I wish. If I want to get 4 Thai names, I have to close and open it four times.
Not that this is a big hassle, I am grateful to swimmer for the work that went into it. I just am not that good with excel at this level.
|
For Excel 2003 I changed the formulas as follows:
Ethnic Names Tab -- Column D, Row 3 Formula Was --
=RANDBETWEEN(1,C3)
I changed to --
=RAND()*(C3-1)+1
Then copied that formula for the remaining cells in Column D and Column I.
This eliminated my ?Name error and appears to be calculating correctly.
Nations Tab -- Column L, Row 2 Formula Was --
=RANDBETWEEN(1,100)
I changed to --
=RAND()*(100-1)+1
Then copied that formula for the remaining cells in Column L
I believe those were the only formulas I had to change. Any F9 (I think almost anything you do -- enter, etc.) will re-randomly generate.
The biggest negative I've seen so far is that you will get the same name for an Iraqi or Iranian or Lebanese (etc. etc.). It's not an issue, you can just as easily re-randomly generate, but it's something you notice. They pull from the same ethinic group and it pulls this once from that tab.
Hope that helps!