I can use indirect or index to randomly retrieve data from a 10,000 long array,Excel WorkbookC60.09413991470.136214049Sheet1Excel 2007Cell FormulasCellFormulaC6=INDEX(Sheet4!A1:A10000,RANDBETWEEN(1,10000))C7=INDIRECT("Sheet4!A"&RANDBETWEEN(1,10000))
which method will be more efficient? How can...