Hey guys. I'm not real sure how to best go about this, so I'm hoping someone can lend me a hand.
I have a huge list of customers in an excel file that was just handed to me. It basically has customer info such as name, address, phone, SSN, account type. I need to delete every record of a customer with account type "Checking." This would be easy enough, but my problem is that when I find a user with a checking account, I also need to delete all other records of this customer from the spreadsheet. The customer may have several different listings with different account types.
For example:
John Smith | 123 5th Street | 123-123-1234 | Checking
John Smith | 123 5th Street | 123-123-1234 | Savings
John Smith | 123 5th Street | 123-123-1234 | Time Deposit
Because John Smith has one record with a Checking account, I need to remove that and then I also need to remove the other records of the same person but different account type. Many thanks in advance to anyone that volunteers to help me with this.
I have a huge list of customers in an excel file that was just handed to me. It basically has customer info such as name, address, phone, SSN, account type. I need to delete every record of a customer with account type "Checking." This would be easy enough, but my problem is that when I find a user with a checking account, I also need to delete all other records of this customer from the spreadsheet. The customer may have several different listings with different account types.
For example:
John Smith | 123 5th Street | 123-123-1234 | Checking
John Smith | 123 5th Street | 123-123-1234 | Savings
John Smith | 123 5th Street | 123-123-1234 | Time Deposit
Because John Smith has one record with a Checking account, I need to remove that and then I also need to remove the other records of the same person but different account type. Many thanks in advance to anyone that volunteers to help me with this.