returning one arguement from several columns
 

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

returning one arguement from several columns
 

Hi,

For numbers

=MAX(A1:C1)

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

Mike


"Reza" wrote:

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