Support Board
Date/Time: Sat, 22 Feb 2025 17:47:47 +0000
[Programming Help] - Spreadsheet programming help - id row from a MAX calculation
View Count: 850
| [2021-02-03 19:05:21] |
| User183724 - Posts: 191 |
|
need to identify the row (/column ) cell from a MAX calculation example: =MAX(BS3:BS1000) value = 3832.25 what row (/column) is the data located in is what is need to determine. I already know the column so I really don't need that now but may in the future. thx tim |
| [2021-02-04 01:59:24] |
| User183724 - Posts: 191 |
|
I'm getting close to what I want with this: =MATCH(MAX(BS3:BS1000), BS3:BS1000, 0) I'd like to try the GetCorrespondingMatch but so far havent had any luck. If somebody has an example of using this one I'd appreciate seeing it |
| [2021-02-04 04:25:49] |
| Sawtooth - Posts: 4174 |
|
Tell me how the row number of that max value will be used. Are you wanting to return a value in that row from another column? Are you wanting to count the bars since that row? |
| [2021-02-04 04:39:00] |
| User183724 - Posts: 191 |
|
actually, both. right now im working on a formula to find the bar number (from bar number study in one column) for the value received from the MAX formula. i can calculate it if i have the number of bars ago the MAX occured so i may wind up using either methiod
|
| [2021-02-04 14:49:45] |
| Sawtooth - Posts: 4174 |
|
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) |
| [2021-02-04 15:35:04] |
| User183724 - Posts: 191 |
|
do u have an example of GetCorrespondingMatch you could share
|
| [2021-02-04 16:18:19] |
| Sawtooth - Posts: 4174 |
|
GetCorrespondingMatch does the same thing as the INDEX/MATCH combo. I never use it. What are trying to 'get'? |
| [2021-02-04 16:56:32] |
| User183724 - Posts: 191 |
|
I'd just like to see an example of it. Ive been trying to work with it because SC says it's so much better than MATCH. But like most stuff, they don't give enough information or show examples for someone to implement it. so I'm just asking around to see if anyone is familiar with it.
|
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: