Forum Discussion
Excel formula
I'm using this formula for bootstrapping in excel but do not work
=INDEX($A$2:E7 RANDBETWEEN(1, ROWS($A$2:$A$16)), 1)
any suggestion for correction?
1 Reply
It seems like you are trying to use the INDEX function with the RANDBETWEEN function to randomly select a row from the range A2:E7. However, there is a syntax error in your formula. You need to separate the two functions properly and ensure that the RANDBETWEEN function generates a valid row number.
Here is the corrected formula:
=INDEX($A$2:$E$7, RANDBETWEEN(1, ROWS($A$2:$A$7)), 1)
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
