Support Board
Date/Time: Fri, 12 Dec 2025 07:32:09 +0000
Post From: Spreadsheet programming help - id row from a MAX calculation
| [2021-02-04 14:49:45] |
| Sawtooth - Posts: 4298 |
|
This will return the number of bars ago the Max occurred: =MATCH(MAX(BS3:BS1000), BS3:BS1000, 0) -1 This will return the bar's volume at the Max of BS3:BS1000: =INDEX(F3:F1000,MATCH(MAX(BS3:BS1000), BS3:BS1000, 0),1) |