Support Board

Date/Time: Sun, 28 Apr 2024 18:18:44 +0000

Post From: Spreadsheet Programing - MAX function question

[2021-11-30 03:59:27] Link To Thread - Link To Post [Go To First Post]
User183724 - Posts: 183
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