Results 1 to 3 of 3

Thread: Excel Help

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: Excel Help

    I have an Excel sheet that looks like this:

    Name: Name1
    Company: Company1
    email: email1

    Name: Name2
    Company: Company2
    email: email2

    Name: Name3
    Company: Company3

    Name: Name4
    Company: Company4
    email: email4

    As you can see, some entries have a name, company, and email, while others only have name and company. I would like to know how to delete only those entries that have a name and company, but no email. Is this possible?
    Thanks

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    Here is a formula and attached Excel example of how to mark rows to delete, where there is no "email:" label. The asterisk symbol * means AND, the plus symbol + means OR.

    =IF((A1="Company:")*(A2="")+(A1="Name:")*(A3="")," DEL","")

    Then you delete all rows with "DEL" displayed.

    The formula reads: if column A cell is "Company:" and the next cell is blank, or if column A cell is "Name:" and 3rd cell down is blank, then display "DEL", otherwise display nothing.

    Jerry
    Attached Files Attached Files

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    Thank you very much. That was a huge help!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •