On Tue, 6 Jan 2009 14:26:00 -0800, veryeavy
wrote:

Thanks Ron,

Looking at it now in the cold hard light of my third day back at work after
my summer holiday I have no idea whatsoever why I thought I needed to
overcomplicated this so much. Sunstroke maybe?

I have incorporated your formula in the final workbook.

It was very tempting to leave the complicated version in my workbook and I
will keep this up my sleeve if I ever want to muddy the waters in the future!

Best Regards,

Matt


I've occasionally done the same thing -- an overly complicated solution to
something that can be solved quite simply.

But glad to help. Thanks for the feedback.
--ron