On Thu, 27 Sep 2007 06:32:02 -0700, Gaffnr
wrote:

Hi Ron
Thanks for this but it doesnt work either.
looks like ive found something that Excel cannot do.
rob
--
Rob Gaffney

I doubt that very much.

Either you have not explained your requirements clearly, or you are not
implementing properly the solutions that have been offered.

You will have a better chance if you provide specific data. But with what you
have provided, we can only guess at what might work.
--ron