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