I am not Max but IV is the last column in Excel 97 - 2003 (in 20047 it will
be XFD
The reference to A1 and ROW is because ROW(A1) will return 1 (A1 is the
first row)
and copied down it will return ROW(A2) = 2 and so on
I would personally use ROWS($A$1:A1) since it is unaffected by inserting
rows above it
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"Richard J" wrote
in message ...
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