Max,
You are a genius! It works a treat, not sure how it works but it
works. I wanted to put the category titles in column A, but that messed
things up a bit, so I moved to column C and then it worked in B,
proberbly because of your reference to A in the formula.
You are right about deleting entire rows etc, I tend to do that and
must be more careful in future.
Just one last question, what is the 'IV' in the formula and why
reference the A column?
Thanks a lot,
Richard.
--
Richard J
------------------------------------------------------------------------
Richard J's Profile:
http://www.excelforum.com/member.php...o&userid=36962
View this thread:
http://www.excelforum.com/showthread...hreadid=566844