Support Board
Date/Time: Sun, 06 Jul 2025 09:36:16 +0000
Post From: Spreadsheet programming help - id row from a MAX calculation
| [2021-02-04 14:49:45] |
| Sawtooth - Posts: 4235 |
|
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) |