Support Board

Date/Time: Wed, 01 Jan 2025 10:51:25 +0000

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

[2016-01-19 14:35:18] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4144
Sorry for the delay in responding. The following comments are based on v1355. Does GetCorrespondingMatch in 1354 meet all of your requirements? 1a. Not yet. See #2 below. (An optimized INDEX/MATCH would.) Do you need the capability for multicolumn search? 1b. I've never had the need, but maybe others might. Is there any reason why you would need to rely on MATCH any longer? 2. Yes -GETCORRESPONDINGMATCH is untested in all situations where I use INDEX/MATCH. -Attached scss is an example. MATCH is used in column Y to assign descending numbers to each row, then formulas in columns T-X return the offset row that INDEX uses in columns H & I to return the corresponding values at the implied value of 1. Do all of the performance improvements as of version 1354 make using New Spreadsheets of acceptable performance? 3. Not yet. Performance of INDEX/MATCH and GETCORRESPONDINGMATCH in the test spreadsheet are now acceptable, but only if I'm not connected to TransAct. When connected to the data feed, there is lag at every chart update.


Zigzag previous legs.scss - Attached On 2016-01-19 14:25:27 UTC - Size: 105.28 KB - 443 views Zigzag previous legs.cht - Attached On 2016-01-19 14:34:10 UTC - Size: 48.09 KB - 466 views