Need max values formula

[mahesh8498]

Hi All,

I need a help to create a formula for below table. I need a sum 1 max values of each row. In below table i need a formula which will find 2 max values in given 4 values and make sum of it. But i need the header of the same instead of value.

In first example i need formula in E column which will find highest value and second highest value. like as 11 + 9 (Values are in column C and B) and i need result in column E as C&B

A B C D
7 9 11 1
12 50 10 9

 

[Matt Rogers]

Hi.

Is it correct?

<table valign="middle" colspan="7" style="font-family:Calibri; color:#000000; background-color:#FFFFFF; font-size:11px; font-weight:normal; font-style:normal; " border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="31,2pt"><col width="31,2pt"><col width="31,2pt"><col width="31,2pt"><col width="31,2pt"><col width="31,8pt"></colgroup><tbody><tr style="background-color:#cacaca"><td>
</td><td align="center">A</td><td align="center">B</td><td align="center">C</td><td align="center">D</td><td align="center">E</td><td align="center">F</td></tr><tr><td style="background-color:#cacaca" align="center">1</td><td align="right">7</td><td align="right">9</td><td align="right">11</td><td align="right">1</td><td align="right">11</td><td align="right">9</td></tr><tr><td style="background-color:#cacaca" align="center">2</td><td align="right">12</td><td align="right">50</td><td align="right">10</td><td align="right">9</td><td align="right">50</td><td align="right">12</td></tr><tr><td style="background-color:#cacaca" align="center">3</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color:#cacaca" align="center">4</td><td align="right">7</td><td align="right">9</td><td align="right">11</td><td align="right">1</td><td align="right">20</td><td align="right">
</td></tr><tr><td style="background-color:#cacaca" align="center">5</td><td align="right">12</td><td align="right">50</td><td align="right">10</td><td align="right">9</td><td align="right">62</td><td align="right">
</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Calibri; font-size:10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40pt"><col></colgroup><tbody><tr style="background-color:#eeaaaa"><td>Zelle</td><td>Formel</td></tr><tr><td>E1</td><td>=LARGE(A1:D1,1)</td></tr><tr><td>F1</td><td>=LARGE(A1:D1,2)</td></tr><tr><td>E2</td><td>=LARGE(A2:D2,1)</td></tr><tr><td>F2</td><td>=LARGE(A2:D2,2)</td></tr><tr><td>E4</td><td>=LARGE(A4:D4,1)+LARGE(A4:D4,2)</td></tr><tr><td>E5</td><td>=LARGE(A5:D5,1)+LARGE(A5:D5,2)</td></tr></tbody></table>

 

[mahesh8498]

I need a formula which will find highest and second highest vallue and will reflect only their header. As in first example it should be in cell E1 written as C&B as value are high in coloumn C and B only

 

[mahesh8498]

I am trying to get header of MAX values..

So inshort formula needs to do find first 2 highest value and then their headers

 

[taurean]

Try:

Excel Workbook
	A	B	C	D	E
1	A	B	C	D	E
2	7	9	11	1	C & B
3	12	50	10	9	B & A
Sheet2

 

[Matty]

If there aren't headers in row 1, could you live with this?

=ADDRESS(ROWS(E$1:E1),MATCH(LARGE(A1:D1,1),A1:D1,0),4)&"&"&ADDRESS(ROWS(E$1:E1),MATCH(LARGE(A1:D1,2),A1:D1,0),4)

Matty

 

[mahesh8498]

Greatttttt..............its working...........Thanks...............