benchmark speed

  1. W

    Speed of Indirect or Index

    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...

Some videos you may like

This Week's Hot Topics

Top