Gurus,
I understand that logical expressions such as AND, OR can be used with IF...THEN such as
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
i.e. IF...AND...THENPlease Login or Register to view this content.
BUT...is it possible to meet the criteria of the IF, then perform two or more operations following the THEN if this single criteria is met?
i.e. IF...THEN...AND
One caveat...the initial criteria is deleted.
I want to search Column A for the word "Member" and then delete the row and all of the subsequent blank rows that follow because they contain member related information.
Please Login or Register to view this content.
Spreadsheet looks like this:
Member Name Address
xxx yyy
xxx yyy
Hopeful Name Address
aaa bbb
aaa bbb
Hopeful Name Address
aaa bbb
(Note "xxx" and "aaa" are in column Name and "yyy" and "bbb" are in column Address.)
This an extract from another program with contains hundreds of entries.
I understand the importance of working backwards when deleting, but I need to delete based on "Member" criteria. Working backwards seems...wow!
Or is there just a better way?
Thank you!!!
Bookmarks