ATTN Frostmarrow: My Excel Hero!!

[CRGreathouse]

.

 

[Angelsboi]

emailed ya charles =)

 

[CRGreathouse]

Oops - the version I sent you works properly, but is formatted so it looks like it's drawing from 1d4+1 instead of 1d3+1. It actually works properly, though.

Here's the heart of the program:

=IF(A3<=B$1,LOOKUP(INT(RAND()*8)+1,Data!A$2:A$9,Data!B$2:B$9),"")

It draws a random value from the "Data" sheet (B2:B9) if A3 is no greater than B1, where B1 is the total # of objects to draw.

 

[Angelsboi]

emailed ya again charles