I'm currently trying to remove rows conditionally for a mail merge. If a next of kin needs a letter their full name will be filled in the comments box and if it matches up the letter gets sent, what I'm looking for is:
If column 'Address_type' doesn't equal 'Main Address' and columns 'Firstname' and 'Surname' together do not equal column 'comments1' remove row and close the gap.
Any help would be much appreciated.
Thanks,
Lex
Bookmarks