Support Board

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

Date/Time: Sat, 10 May 2025 07:34:06 +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: 4214
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 - 469 views scwbf speed test 2.scwbf - Attached On 2015-12-27 05:09:03 UTC - Size: 56.7 KB - 397 views