SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2584737%22%20slang%3D%22en-US%22%3EGet%20the%20the%20header%20from%20an%20dynamic%20array%2C%20created%20with%20sequence.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584737%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20spread%20sheet%20that%20find%20the%20largest%20number%20for%20the%20ast%203%20months.%20But%20how%20to%20I%20get%20the%20righet%20header%2C%20here%20it%20should%20be%20%22Aug%22%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22header%20of%20largest.PNG%22%20style%3D%22width%3A%20956px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298251i3E0E1132DEB37EC9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22header%20of%20largest.PNG%22%20alt%3D%22header%20of%20largest.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EExample%20file%20is%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2584737%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584949%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20the%20header%20from%20an%20dynamic%20array%2C%20created%20with%20sequence.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9195%22%20target%3D%22_blank%22%3E%40Geir%20Hogstad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20take%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fget-location-of-value-in-2d-array%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20formula%3A%20Get%20location%20of%20value%20in%202D%20array%20%7C%20Exceljet%3C%2FA%3E%26nbsp%3Bas%20the%20basis%20to%20find%20proper%20column%20and%20it's%20header%20name.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2585004%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20the%20header%20from%20an%20dynamic%20array%2C%20created%20with%20sequence.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2585004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9195%22%20target%3D%22_blank%22%3E%40Geir%20Hogstad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20the%20permission%20of%20everyone%2C%20here%20is%20an%20additional%20example%20with%20simple%20formulas.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2585023%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20the%20header%20from%20an%20dynamic%20array%2C%20created%20with%20sequence.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2585023%22%20slang%3D%22en-US%22%3EThank%20you%2C%20worked%20perfect.%20I%20have%20to%20learn%20MMULT%20better.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20Regards%3CBR%20%2F%3E-%20Geir%3C%2FLINGO-BODY%3E
Regular 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 (Regular 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)