Let's say I have 4 columns, how do I go about returning the right most
value?

As you can see, the right most value could be in any cell in the
range.

So for row 1, I'd like to return 'fail', row 2 would be blank, row 3
would be start.

THANKS!!


+-------------------------------------------------------------------+
|Filename: excel_help.gif |
|Download: http://www.excelforum.com/attachment.php?postid=2800 |
+-------------------------------------------------------------------+

--
bimmerman
------------------------------------------------------------------------
bimmerman's Profile: http://www.excelforum.com/member.php...fo&userid=2623
View this thread: http://www.excelforum.com/showthread...hreadid=319534