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,

Forget my follow up. I see what you mean. The 2s referred to row 2. In
my particular example I clearly need to change the 2:2 to a specific
range e.g. E2:AA2

That's brilliant. Works perfectly. I just need to sit down and
understand it now!

Many thanks again,

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________