Indexing max from every other cell

[TheOx2k]

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

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TAKE(SORT(FILTER(VSTACK($I$2:$AP$2,I15:AP15),MOD(SEQUENCE(,COLUMNS(I15:AP15)),2)=0),2,-1,1),1,1)

 

[TheOx2k]

Hi Fluff, thank you very much, that worked a treat.

If I wanted to average the same cells, how would the best way to do that be?

 

[Fluff]

In the 2nd formula you posted just swap Max for Average.