-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
speed comparison
-
G
What is fastest formula and input setting between INDEX-MATCH, INDEX-XMATCH, and XLOOKUP?
Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...- gifariz
- Thread
- index lookup match performance speed comparison xlookup xmatch
- Replies: 3
- Forum: Excel Questions
-
M
Excel and Windows 10 - Speed issue
Hello Fellow Excel Users, I have a computer dilemma that I am hoping you can give me some advice. I have a Excel macro that analysis a data file and generate 18 or more graphs. It works, and a thank you to all who helped me from this forum, but does take about 8 minutes to run. I will run...- mikejvir
- Thread
- excel speed comparison windows 10 64 bit windows 7 64 bit
- Replies: 7
- Forum: General Discussion & Other Applications
-
T
XL parallel on Windows, not on OS X, but why is my serial VBA code slower?
I'm probably beating a dead horse here...poor horse. Does anyone know the reason why the same VBA code runs slower in OS X (Excel 2008/2011) than it does in Windows (Excel 2007/2010/2013)? I've written several cross-platform Excel VBA projects for Excel 2011/2010/2013, and I've noticed that...- twilsonco
- Thread
- os x speed comparison vba windows
- Replies: 3
- Forum: Excel Questions
