Hi, I feel this might be simple, but if you are able to help, would be appreciated.
I have an excel sheet that returns the max value in an array and returns the date from the same column row 2. "=IF(SUMPRODUCT(--(I15:AP15<>""))=0,"",INDEX($K$2:$AR$2,0,MATCH(MAX(I15:AP15),I15:AP15,0)))"
However, I would like to find the max from every other column and return the date from row 2.
I am using "=MAX(FILTER(I15:AP15,MOD(SEQUENCE(,COLUMNS(I15:AP15)),2)=0))" to return the max value for every other column in an array. However, am struggling to return the date from row 2.
Thanks
I have an excel sheet that returns the max value in an array and returns the date from the same column row 2. "=IF(SUMPRODUCT(--(I15:AP15<>""))=0,"",INDEX($K$2:$AR$2,0,MATCH(MAX(I15:AP15),I15:AP15,0)))"
However, I would like to find the max from every other column and return the date from row 2.
I am using "=MAX(FILTER(I15:AP15,MOD(SEQUENCE(,COLUMNS(I15:AP15)),2)=0))" to return the max value for every other column in an array. However, am struggling to return the date from row 2.
Thanks