Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sun, 29 Dec 2024 14:32:14 +0000

Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available

[2015-12-27 05:11:14] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4143
Attached are the comparison spreadsheet studies. This is a severe test using cascading formulas in row 1 referenced by an INDEX/MATCH formula in row 3 of each of 60 columns for 1000 rows. Change the value in K1 to affect the entire sheet. The New Spreadsheets sheet takes about 100 times longer to recalculate the array than the Old Spreadsheets sheet, e.g. 100 seconds vs 1 sec.
0x Thank you
scss speed test 2.scss - Attached On 2015-12-27 05:08:02 UTC - Size: 160.15 KB - 440 views scwbf speed test 2.scwbf - Attached On 2015-12-27 05:09:03 UTC - Size: 56.7 KB - 380 views