Forum Discussion
Problem with INDEX and RANDBETWEEN
I am trying to sample randomly from a column of numbers using a combination of the INDEX and RANDBETWEEN functions. The formula was "=INDEX($C$15:$C$213,RANDBETWEEN(15,213)" - this was failing on a r...
Thanls, SergeiBaklan! I must of had a brain cramp today - I don't know why I kept trying to set to worksheet row number rather than array row number.
tpmcmahon , no problem, happens with all of us. Glad to help.