Hi Bob

Thanks for your reply, however for the life of me I can't get that to
work.

Putting the "N" function in front of the "Offset" seems to turn the
whole of the second part of the formula into a single number, whereas
is needs to be an array.

I tried adding the "N" in front of the "Column" function, but no luck
with this either.

Any other ideas would be greatly appreciated

Many thanks

Peter


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=502377