Index Column Heading

[agutts6]

<table style="width: 576px; height: 1px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="9"><tbody></tbody></table>How do I look up a column heading with a maximum value? Here's hoping this displays decently...

<table border="0" cellpadding="0" cellspacing="0"><tbody> </tbody></table>
<table width="320" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">Name</td> <td style="width: 48pt;" width="64">2B</td> <td style="width: 48pt;" width="64">SS</td> <td style="width: 48pt;" width="64">3B</td> <td style="width: 48pt;" width="64">1B</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Joe</td> <td align="right">23</td> <td align="right">45</td> <td align="right">0</td> <td align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Steve</td> <td align="right">0</td> <td align="right">0</td> <td align="right">60</td> <td align="right">0</td> </tr> </tbody></table>

Basically, I want it to return 'SS' for Joe, and '3B' for Steve.

Much appreciated.

--AG

 

[T. Valko]

<TABLE style="WIDTH: 576px; HEIGHT: 1px" cellSpacing=0 cellPadding=0 border=0><COLGROUP><COL style="WIDTH: 48pt" span=9 width=64><TBODY></TBODY></TABLE>How do I look up a column heading with a maximum value? Here's hoping this displays decently...

<TABLE cellSpacing=0 cellPadding=0 border=0><TBODY></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=320 border=0><COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="WIDTH: 48pt; HEIGHT: 15pt" width=64 height=20>Name</TD><TD style="WIDTH: 48pt" width=64>2B</TD><TD style="WIDTH: 48pt" width=64>SS</TD><TD style="WIDTH: 48pt" width=64>3B</TD><TD style="WIDTH: 48pt" width=64>1B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" height=20>Joe</TD><TD align=right>23</TD><TD align=right>45</TD><TD align=right>0</TD><TD align=right>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" height=20>Steve</TD><TD align=right>0</TD><TD align=right>0</TD><TD align=right>60</TD><TD align=right>0</TD></TR></TBODY></TABLE>

Basically, I want it to return 'SS' for Joe, and '3B' for Steve.

Much appreciated.

--AG

Try this...

Book1
	A	B	C	D	E	F
1	Name	2B	SS	3B	1B	Position
2	Joe	23	45	0	0	SS
3	Steve	0	0	60	0	3B
Sheet1

Formula entered in F2 and copied down:

=INDEX(B$1:E$1,MATCH(MAX(B2:E2),B2:E2,0))

Note that if there are multiple instances of the max value in a row the formula will match the left -most instance.

 

[agutts6]

Worked very well. Thank you Valko!

 

[T. Valko]

Worked very well. Thank you Valko!

You're welcome. Thanks for the feedback!