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