Hi all
I have an IF formula resulting in TRUE or FALSE for S1:AT1.
When false, I want to select rows 10:54 in that column to delete and shift left. Only cell/formula that may be disrupted is in row 1. There is data beneath row 54 that needs to remain so cannot delete entire column.
From searching the forum, I think I might need to use a UNION, but have never done so, and hoping someone could please assist?
Thank you.
I have an IF formula resulting in TRUE or FALSE for S1:AT1.
When false, I want to select rows 10:54 in that column to delete and shift left. Only cell/formula that may be disrupted is in row 1. There is data beneath row 54 that needs to remain so cannot delete entire column.
From searching the forum, I think I might need to use a UNION, but have never done so, and hoping someone could please assist?
Thank you.