Forum Discussion
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...
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))))
With the permission of everyone, here is an additional example with simple formulas.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Thank you for investing time in this. Good solution, but not for my problem here 🙂 I was trying to lookup the month.
/Geir- I am pleased that Mr. Baklan's proposed solution has led you to the solution of your problem.
Furthermore, I wish you much success with Excel.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
