Formula help

[Ron99]

Hello,

I have a below data in columns

ron	4	shawn	3	max	8
jack	2	rex	1	swan	12

<tbody>
</tbody>

The next column I need a output showing the maximum. example - in the 1st row the maximum number is 8 but I need the ouput as max, same with the 2nd row, maximum is 12 and I need the output swan.

Please let me know the formula which I can use.

Thanks,
Ron

 

[Marcelo Branco]

Try

=INDEX(A1:F1,MATCH(MAX(A1:F1),A1:F1,0)-1)

M.

 

[GiorgiPepe]

you could use this little formula:

Function FindMax(MaxVal As Integer, SearchRng As Range)


Dim cell As Range


For Each cell In SearchRng
If cell = MaxVal Then
FindMax = cell.Offset(0, -1)
Exit For
End If
Next cell


End Function

 

[Ron99]

Thank you very much...cheers!!