One other note... The part of the formula ...ROW(1:1000) when I copy it down
to other rows automatically incriments IE: ROW(2:1002), ROW(3:1003) etc.
Because I don't understand how the formula works, I don't know the affect
this has on the results. Does it matter?
--
Thanks in advance!
**John**


"smartin" wrote:

John wrote:
XL says it will not work in merged cells... anyway around this?

I would get rid of merged cells if I were you. If merged cells is
absolutely critical to the formatting/presentation, a work-around might
be to do the calculations on a worksheet with no merged cells, then look
up the values on a formatted worksheet.

BTW "merge and center" can effectively be replaced with no merged cells.
Select the cells in question and apply Format | Cells | Alignment |
Horizontal | Center Across Selection.