Tip: Other languages are Google-Translated. You can visit the English version of this link.
or

Register

or
0
0
0
s2smodern

How to find highest value in a row and return column header in Excel?

In this article, I will talk about how to return the column header of the largest value in a row in Excel. For Example, I have the following data range, column A is the year, and column B to F are populated the order numbers from Jan to May. And now, I want to get the month name of the largest value in each row.

Find highest value in a row and return column header with formula

 Select or highlight cells with max & min value in a range of cells or each column or row: Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.

Find highest value in a row and return column header with formula

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

To retrieve the column header of the largest value in a row, you can apply a combination of INDEX, MATCH and MAX functions to get the result. Please do as follows:

1. Enter this formula into a blank cell you need: =INDEX(\$B\$1:\$F\$1,0,MATCH(MAX(\$B2:\$F2),\$B2:\$F2,0)), and then press Enter key to get the month name which matches the largest value in a row. See screenshot:

2. And then select the cell and drag the fill handle over to the range that you want to contain this formula, see screenshot:

Note: In the above formula: B1: F1 is the headers row that you want to return, B2: F2 is the data range which contains the largest value you want to find.

Related article:

How to find the highest value and return adjacent cell value in Excel?

Recommended Productivity Tools

Office Tab

Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

200 New Features for Excel, Make Excel Much Easy and Powerful:

• Merge Cell/Rows/Columns without Losing Data.
• Combine and Consolidate Multiple Sheets and Workbooks.
• Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
• Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,

Say something here...
symbols left.
or post as a guest, but your post won't be published automatically.
• To post as a guest, your comment is unpublished.
· 9 months ago
Thank you so much!!!
• To post as a guest, your comment is unpublished.
· 11 months ago
Hi, am trying to find lowest value in a row and the highest value on the corresponding column. Is there a formula or shortcut to find this. Please guide
• To post as a guest, your comment is unpublished.
· 11 months ago