Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software, IT » Use Excel VBA to Test Report Calculation Times

Use Excel VBA to Test Report Calculation Times

I recently exchanged email with an Excel expert who had concluded that VLOOKUP was Excel’s fastest lookup method. It was even faster, he said, than INDEX-MATCH. To support this surprising conclusion, he sent me his testing macro. The macro was cleverly written, but had two fatal flaws. First, his testing method had so much overhead [...]

For more information visit Use Excel VBA to Test Report Calculation Times

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT

Comments are closed.