Support Board
Date/Time: Sun, 20 Sep 2026 00:57:52 +0000
Post From: Spreadsheet programming help - id row from a MAX calculation
| [2021-02-04 14:49:45] |
| Sawtooth - Posts: 4354 |
|
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) |