Forum Discussion

Iron Contributor

Jul 25, 2021

Solved

Get the the header from an dynamic array, created with sequence.

Hi, I have an spread sheet that find the largest number for the ast 3 months. But how to I get the righet header, here it should be "Aug": Example file is attached. Best Regards - Gei...

get largest description.xlsx11 KB

excel

Formulas and Functions

SergeiBaklan
Jul 25, 2021
Hogstad_Raadgivning

You may take this Excel formula: Get location of value in 2D array | Exceljet as the basis to find proper column and it's header name.

=INDEX(B11:M11,1,SUM(MMULT(--(B12:M19=E3),SEQUENCE(12))))
get largest description.xlsx11 KB

Hogstad_Raadgivning

Iron Contributor

Jul 25, 2021

Thank you, worked perfect. I have to learn MMULT better.

Best Regards
- Geir

SergeiBaklan

Diamond Contributor

Jul 26, 2021

Hogstad_Raadgivning , you are welcome