returning one arguement from several columns

[Reza]

Heya,

I have three columns, there is one value in each of the rows (2 blank
values). I am trying to find a function that returns the one value, so it
would neet to search the three columns and return the one that has a value in
it.

Thanks very much,
Reza

 

[Mike H]

Hi,

For numbers

=MAX(A1:C1)

or for text
=LOOKUP(REPT("z",255),A1:C1)

Mike