Support Board
Date/Time: Thu, 23 Jan 2025 05:09:49 +0000
Post From: I'm not able to make GETCORRESPONDINGMATCH spreadsheet function to works
| [2018-11-06 23:36:39] |
| Sawtooth - Posts: 4162 |
|
I don't know why =MATCH($AC$1,AB3:AB9,1)+2 doesn't see the 6. =NMATCH(1,$AC$1,AB3:AB9,0)+2 does see it. Have a look at the NMATCH function. You'll need a separate Formula Column for each use of the NMATCH. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#NMATCH_Function FYI, this formula returns the same as =MATCH($AC$1,AB3:AB9,0)+2 where the formula is in Q3: =IF(AB3=$AC$1,3,Q4+1) The 3 is the starting value to be incremented to compensate for the first row being row 3 (1+2=3). Also, look at this example of a way to sort the array in the opposite direction: https://www.sawtoothtrade.com/example-8.html You can modify this example to sort a portion of the array. Once the array is sorted in the opposite direction, you can use =MATCH($AC$1,AB3:AB9,0)+2 or =IF(AB3=$AC$1,3,Q4+1) which does see the 6. |