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
|