Support Board
Date/Time: Sat, 31 Jan 2026 08:11:56 +0000
Post From: Spreadsheet programming help - id row from a MAX calculation
| [2021-02-04 14:49:45] |
| Sawtooth - Posts: 4312 |
|
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) |