Support Board
Date/Time: Fri, 12 Dec 2025 07:37:44 +0000
Post From: Spreadsheet programming help - id row from a MAX calculation
| [2021-02-04 17:21:53] |
| Sawtooth - Posts: 4298 |
|
It might be more efficient but I can't discern a difference. It is more confusing to use, you can't use it with a range of itself, and its name is unnecessarily too long. To return the volume at the Max of BS3:BS1000: =GETCORRESPONDINGMATCH(BS3:BS1000,MAX(BS3:BS1000),0,0,0,F3:F1000,0) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function |