How can my formula handle inserted rows?
Possible solution:
=IF(COUNTBLANK(A$1:INDEX(B:B,ROW()-1))=1,"There are empty cells within the
specified range","All cells within specified range are populated")
"Houston" wrote:
I am using (more likely misusing) COUNTA to validate that all cells within
the specified range are populated, but I have a question regarding how to
handle inserted rows. Here is my current formula:
=IF(COUNTA(A1:A10, B1:B10)=20,"All cells within specified range are
populated")
However, if someone inserts a row between the 1 and 10, the contents in row
10 get shoved to row 11, and I would want to expand my formula range
dynamically to accomodate this insert. How would I accomplish this? Thanks
for any insight!
|