Jul 25 2021 08:49 AM
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
Jul 25 2021 11:17 AM - edited Jul 25 2021 11:26 AM
SolutionYou 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))))
Jul 25 2021 12:32 PM
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)
Jul 25 2021 12:50 PM
Jul 25 2021 12:52 PM
Jul 26 2021 12:27 AM
Jul 26 2021 12:31 AM
@Geir Hogstad , you are welcome
Jul 25 2021 11:17 AM - edited Jul 25 2021 11:26 AM
SolutionYou 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))))