Hello all,
Looking for a simple loop or filter that looks in cell D3:D32 for a word "CLASS SIZE". If that word exists, and if there is a corresponding empty cell in A3:A32, then delete the entire row. Otherwise, leave it alone and move down to the next cell in column D and check that until D33 and quit.
Can someone help with this?
Thank you.
Looking for a simple loop or filter that looks in cell D3:D32 for a word "CLASS SIZE". If that word exists, and if there is a corresponding empty cell in A3:A32, then delete the entire row. Otherwise, leave it alone and move down to the next cell in column D and check that until D33 and quit.
Can someone help with this?
Thank you.