Forum Discussion
Find Highest Value In A Row, Return the column header - across sheets
Hi I'm trying to return the header that matches the highest value in a row but I'm having some trouble with my formula. =INDEX(Sheet2!A1:F1,0,MATCH(MAX(Sheet2!A10:F10,Sheet2!A13:F13),Sheet2!A...
You may take this Excel formula: Get location of value in 2D array | Exceljet as the basis
That's an amazing formula, SergeiBaklan I like exceljet and often use it; glad to see you do too.
Dave makes a great job, he systemises all around Excel. Not to explain this and that from scratch usually it's much better to give link on his resource.