Find highest value in a row and return column header in Excel

The video offers a short tutorial on excel on how to find highest value in a row and return column header.

[anthonnettedevera]

You don’t know how much I’ve been looking for this!! Thank you so much!!

[matejfabijanic]

Exactly what I needed, thank you good Sir

[ILIKEENGLISH]

THIS HELPED ME A LOT THAN YOU, YOU ARE REALLY GREAT

[narindersharma]

hello, in the same formula, Could you help in formula to have all header value in case of min value in more than one cell

[doritlakonishok]

HI. How to do the same but in a range of rows, like instead B6:F6 -> B6:F8... If I do this I get N/A error.

[sudheertiwari]

If i need 2nd and 3rd largest also. then what to do?

[jamescasey]

what if you have two values of that are the same for highest value how do you get both headers to show in the same cell such as if Jan = 100 and Feb = 100?

[creativemind]

If want want the next hieghst value in the same range ? How to do this?

[harsinchh]

Sir,
A B C
20 40 30
(10) 50 [60
20 30 20
50 10 10
60 10 80
30 (90) 50]
20 20 70
From column A min value 10 to column b max value 90, how can I sum column c all cells from min value to max value at column A to column B.

[harsinchh]

How to highlight the column C, range - on the based on max value of column A to min value of column B.
A B C
50 60 1000
30 20 2000
[90] 50 (3000)
30 40 (1000)
20 [10] (5000)
40 80 80000
30 20 10000