returning one arguement from several columns

  • Thread starter Thread starter Reza
  • Start date Start date
R

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
 
Hi,

For numbers

=MAX(A1:C1)

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

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
return proper match from three columns 2
Return the value from one range that does not exist in another 0
returning a different cell value 1
Excel Concatenate with line breaks but ignore blank cells 3
Return the row number of Median value of a column 2
Help needed 0
match question 1

Back
Top