I need to return the value of a cell in a range that is not blank..

A B C D E
1 5 (return 5 in e1)
2 3 (return 3 in e2)
3 4 (return 4 in e3)
4 (return " " in e4)

Put this in E1

=IF(COUNT(A1:D1),INDEX(A1:D1,MATCH(1,--(ISNUMBER(A1:D1)),0)),"")

enter it witrh ctrl + shift & enter
copy it down

why would you want to putr a space in the cell as
opposed to a blank ""?


Regards,

Peo Sjoblom



"kvail" wrote:

I need to return the value of a cell in a range that is not blank..

A B C D E
1 5 (return 5 in e1)
2 3 (return 3 in e2)
3 4 (return 4 in e3)
4 (return " " in e4)

Is it always numeric input?

If yes, I'd just use:

=if(count(a1:d1)=0,"",max(a1:d1))

(and copy down)

kvail wrote:

I need to return the value of a cell in a range that is not blank..

A B C D E
1 5 (return 5 in e1)
2 3 (return 3 in e2)
3 4 (return 4 in e3)
4 (return " " in e4)

--

Dave Peterson