Guys: brilliant many thanks; works a treat. More importantly you have
opened door on Array formulas. I simply hadn't reaslied they existed in
Excel. But I suppose without a first example it doesn't naturally occur
to you that they may solve your problem.
thanks again.

Bob