Support Board
Date/Time: Sun, 29 Dec 2024 14:28:25 +0000
Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available
| [2016-01-08 00:52:29] |
| Sawtooth - Posts: 4143 |
|
In the modified test spreadsheet using GETCORRESPONDINGMATCH, with an ascending ordered list in column K, when changing the formula in K1, the calculations take about 2 seconds, vs 1 second for the scwbf test spreadsheet, (using INDEX/MATCH). This is a marked improvement. However: 1) If you change the formula in K3, it takes about 90 seconds to recalculate the sheet, vs 1 second for the scwbf spreadsheet. If you open the test spreadsheet with an unsorted column K, it takes the same 90 seconds. 2) If you change K3 from =ROW(), which produces an ascending ordered list, to =F3, which produces an unsorted list, GETCORRESPONDINGMATCH returns the matching value one row above the originating value's row, and it also does not repeat the value in rows above, until the next matching value or until the current row 3. See pics. |
 Return value of GETCORRESPONDINGMATCH.PNG / V - Attached On 2016-01-08 00:42:21 UTC - Size: 34.63 KB - 484 views Return value of INDEX-MATCH.PNG / V - Attached On 2016-01-08 00:42:28 UTC - Size: 27.33 KB - 391 views |