Try one of these:

=INDEX(A1:E1,MATCH(REPT("Z",255),A1:E1))

=IF(COUNTIF(A1:E1,"*"),INDEX(A1:E1,MATCH(REPT("Z", 255),A1:E1)),"")


--
Biff
Microsoft Excel MVP


"JulesMacD" wrote in message
...
I have 5 columns containing different supervisor levels. Some columns are
blank. I would like to write a formula to evaluate the 5 columns and
return
the name in the farthest right column. Thank you!