BONDS TEST.xlsx
I'm trying to find the max in column c3:c11 and then give the time in column A that will allow me to drag that formula to find the max and time of c12:c20 etc. The formula I have in column I is =(INDEX(A:A,(ROW(A1)*9)+2)) and in column J is =INDEX(A3:A11,MATCH(MAX(C3:C11),C3:C11,0)). This formula I tried using but it's not right =INDEX(INDEX(A:A,(ROW(A1)*9)-6):INDEX(A:A,(ROW(A1)*9)+2)),MATCH(MAX(INDEX(C:C,(ROW(A1)*9)-6):INDEX(C:C,(ROW(A1)*9)+2)),INDEX(C:C,(ROW(A1)*9)-6):INDEX(C:C,(ROW(A1)*9)+2),0). I attached a picture.
Thanks
JdConner
Bookmarks