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
- Geir
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))))
6 Replies
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)
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))))- Thank you, worked perfect. I have to learn MMULT better.
Best Regards
- GeirHogstad_Raadgivning , you are welcome
