Formula help, please!

[Shawn Martin]

Trying to figure out a formula that will assign the largest number in a row a value. For example, the largest number in the row below is 53, so I would like for the formula to = VSS4. Thanks in advance!

[TABLE="width: 178"]
<colgroup><col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1308;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <col width="41" style="width: 31pt; mso-width-source: userset; mso-width-alt: 1450;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <col width="38" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1365;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <tbody>[TR]
[TD="class: xl63, width: 37, bgcolor: palegreen"]VSS1[/TD]
[TD="class: xl63, width: 40, bgcolor: palegreen"]VSS2[/TD]
[TD="class: xl63, width: 41, bgcolor: palegreen"]VSS3[/TD]
[TD="class: xl63, width: 40, bgcolor: palegreen"]VSS4[/TD]
[TD="class: xl63, width: 38, bgcolor: palegreen"]VSS5[/TD]
[TD="class: xl63, width: 40, bgcolor: palegreen"]VSS6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]0.1[/TD]
[TD="bgcolor: transparent, align: right"]15.5[/TD]
[TD="bgcolor: transparent, align: right"]23.3[/TD]
[TD="bgcolor: transparent, align: right"]53[/TD]
[TD="bgcolor: transparent, align: right"]36.7[/TD]
[TD="bgcolor: transparent, align: right"]7.7[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

The basis of what you want I think is below but ..
a) is it possible and
b) if so what do you want to do if
.. the maximum value occurs more than once in row 2? That is what if 3 cells were all 53?

Excel Workbook
	A	B	C	D	E	F	G	H
1	VSS1	VSS2	VSS3	VSS4	VSS5	VSS6
2	0.1	15.5	23.3	53	36.7	7.7		VSS4
Assign to max