Support Board
Date/Time: Wed, 01 Jan 2025 11:30:58 +0000
Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available
| [2016-01-27 01:00:53] |
| Sawtooth - Posts: 4144 |
|
v1358 has significant performance improvements involving the New Spreadsheets, using my test spreadsheet studies. Performance is equal or better than the Old Spreadsheets. The increased performance might be even more noticeable in situations different than my test spreadsheet revealed, as noted by user @sigmadict. Performance is actually significantly much better than the Old Spreadsheets test spreadsheet, when connected to my data feed, and using INDEX/MATCH in both. However, the GETCORRESPONDINGMATCH function cannot be used in the Zigzag Previous Legs example in post 28, where INDEX and MATCH are not used in the same formula. But that's not a problem since INDEX and MATCH are now also optimized. These performance improvements have allowed the use of INDEX/MATCH combination without any lag in every situation I've tested up to this point. This is much appreciated. Thank you for the time and effort you've put into these performance improvements. |