Support Board
Date/Time: Tue, 04 Mar 2025 11:18:15 +0000
Post From: Spreadsheet Programing - MAX function question
| [2021-11-30 03:59:27] |
| User183724 - Posts: 191 |
|
I got this to do what I want but I'm not sure its what I was after... any port in a storm i guess... =MAX(INDEX (A1:CN1002,(BW3-P3)+3,3):INDEX (A1:CN1002,(BW3-O3)+3,3)) where a1:cn1002 is the entire sheet...could trim this down BW3 is the bar# study...current bar value P3 is a previously stored bar# of an event we want to keep the subtracted difference gives the ROW we need +3 is to position INDEX on cell 3 of the column ,3 is column C ... HIGH of the bar repeat for O3 so, by storing the bar# and going though this mess, I got the overall result i was wanting... thx |