SOLVED

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

Steel Contributor

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":

header of largest.PNG

Example file is attached.

 

Best Regards

- Geir

 

6 Replies
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@Geir Hogstad 

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))))

@Geir Hogstad 

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, worked perfect. I have to learn MMULT better.

Best Regards
- Geir
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)
1 best response

Accepted Solutions
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@Geir Hogstad 

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))))

View solution in original post