Support Board
Date/Time: Sun, 23 Feb 2025 02:26:20 +0000
Post From: Spreadsheet programming help - id row from a MAX calculation
| [2021-02-04 17:21:53] |
| Sawtooth - Posts: 4174 |
|
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 |