On Wed, 30 Mar 2005 16:38:49 +0100, "Bob Phillips"
wrote:

Richard,

Are you wanting a worksheet formula? If so, then try

=INDEX(2:2,1,MAX(IF(2:2<"",COLUMN(2:2)))-COLUMN(2:2)+1)


it's an array formula, so commit with Ctrl-Shift-Enter


Bob,

Thanks for this. An array formula would be fine.

What are the references to 2:2 in your example? I think I may need to
change them to fit my specific worksheet. If it helps the columns I'm
trying to include are E:AA - slightly less than 31 because I don't
have columns for weekends.

Regards,

Richard
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________