How do I pull the column header next to a Max formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a column on the righ of a chart that pulls the max number from
each row. Now I would like to add acolumn next to with the column header of
that row...any suggestions?
 
Hi!

B1:F1 are your column headers
B2:F2 = some numbers
G2 = =MAX(B2:F2)
H2 = formula for corresponding column header

=INDEX(B$1:F$1,MATCH(G2,B2:F2,0))

Copy down as needed.

Biff
 
P.S.

If there are duplicate MAX values the formula will return the header that
corresponds to the first instance of MAX.

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column header for Max value? Index/array function? 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Clear a "moving" range offset from Target 31
How do I sum a column based on 2 different column headers/criteria? 0
excluding column headers from formulas 3
insert column header in cell below result of max FUNCTION 2
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Formula to choose from the last column of a given row 1

Back
Top