D
david
A few days ago, some kind person introduced me to the INDIRECT function
as a way of keeping a formula pointed at a fixed cell even after I've
inserted a column or two on the worksheet. (Thank you!)
Turns out, though, that while I need that fixed reference to a given
column, I actually want a relative reference to the rows on the worksheet.
Does anyone have a suggestion about how to set my formula up so the
reference to a given column is absolute but the row floats?
Thanks!
as a way of keeping a formula pointed at a fixed cell even after I've
inserted a column or two on the worksheet. (Thank you!)
Turns out, though, that while I need that fixed reference to a given
column, I actually want a relative reference to the rows on the worksheet.
Does anyone have a suggestion about how to set my formula up so the
reference to a given column is absolute but the row floats?
Thanks!