Search results

Thanks Luke...Everything is working great...You are a genius!!

Great, Any Secret to copying the contents of the 7 cells to new location? I have tried and only see the first set calculating correctly ($A$1:$C$3).

Luke M, This is really starting to look great!! If the contents of C2&C3 is blank because 'Single' was chosen is there a way to get a 'X' to appear in those cells? Same is true if 'Double' is chosen..is there a way to have a 'X' appear in C3 (blank Cell)?

What I have so far. Sheet 1 -- Has data in Cells $A$1:$E$54 Sheet 2-- A1=CHOOSE(RANDBETWEEN(1,3),"Single","Double","Triple") B1=RANDBETWEEN(1,54) B2=INDEX(IF(ROW(A1:A54)<>B2,ROW(A1:A54)),RANDBETWEEN(1,53))...

Luke M, Thanks for looking over that. Still fuzzy on your answer. Where is 'Double' referenced in the function? Basically I want to see one random row of Data on Sheet 2 that comes from A1 through E1 or up to A54 through E54 from Sheet 1 if Sheet 2's A1 = 'Single' (chosen at random...

Data is on Sheet 1, Function is on Sheet 2 In Columns A1 through E1 on Sheet 1 54 Rows on Sheet 1 What I need: A1 on Sheet 2 needs to Randomly choose 'Single','Double',or'Triple' B1 =If A1 = 'Single' then display one row using ($A$1:$E$54) from Sheet 1 output to $C$1:$G$1 on Sheet 2 =If...

Hui..Thanks for finding that. Amazing.

Hui, You are incredible..That works!!

Indian, I used =IF(A7<19,"Singles --- "&RANDBETWEEN(1,19),IF(AND(A7>18,A9<37),"Doubles --- "&RANDBETWEEN(20,91),IF(A7>36,"Triples --- "&RANDBETWEEN(92,215),""))) Sometimes when I recalculate (F9 in 2003, autocalculation is turned off). I get a blank or null value from the...

A7~~=RANDBETWEEN(1,54) B7~~=IF(A7<19,RANDBETWEEN(1,19),IF(AND(A7>18,A7<37),RANDBETWEEN(20,91),IF(A7>36,RANDBETWEEN(92,215),""))) What I would like to accomplish is displaying a Word or some variable characters along side the random numerical number chosen in B7. For...

Fantastic...I forgot that I had automatic calculation turned off ;P...Looks like everything is working good now :) Thanks for all the help!!

Oldchippy, I installed the Add-in. When in Data analysis I should select the Random Number Generation, correct? What values should I use for each field? Thanks!

Oldchippy, Thanks for reply. That was a typo indeed. The values were <20 returns 1-19, >19 or <37 returns 1-73, and >36 returns 1-127. All the returns are random...

What I am trying to accomplish Cell A7 uses =ROUND((RAND()*(0-54)+54),0) to give me rounded whole number between 1 and 54 Cell B7 uses this function =IF(A7<20,ROUND((RAND()*(0-19)+19),0),IF(A7>19,ROUND((RAND()*(0-73)+73),0),IF(A7>73,ROUND((RAND()*(0-127)+127),0)))) 2 Problems...