Could you put the two spreadsheets in one workbook (if they aren't already) and attach the file here so I can work on it
Here is how to attach it:
So you want to delete from column B all names that do not have a match in column A. Correct?
Correct, I need to keep the duplicate names in column B that match Column A. Those matches up with multiple accounts for the individual. I need the names in Column B that do not match column A to be removed. Example: Abney,Thomas is in column B, but not in column A. I need all records for Abney,Thomas to be removed.
Ok here are the formulas (in the yellow cells) which identify with an "X" the names in column B that do not have a match in column A. You can copy the formulas to as many rows down as you need, or to any other spreadsheet
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
I ran the formula and it did add the X to the correct records. I was expecting to sort on column C to move all the X's together to delete the records, but I am unable to do it. I went to Custom sort and selected column c to sort upon. It sorts, but leave the X's in the same location. I also tried to add column D and copy/paste special the X's, but the same thing happened. Any ideas?
No I was just showing you the formulas. I could have sent you the end result but you wouldn't be able to see the formulas after the data has been processed and deleted
Here is the file after deleting the
Hope this helps
The formulas are in the yellow cells in the first file that I sent you
Thank you for clicking Accept if you are satisfied with the solution. I will be happy to assist you further after that
I can send you the step by step instructions if you like
No problem I will prepare now the instructions to achieve the final result. In the meantime you can click accept if the results are correct as shown in the last file
Ok assuming you are using Excel 2007 or 2010
1- Open the file that I sent you first (with the formulas)
2- Select the entire column C (that has the formulas)
3- Copy it, then while it is still selected right click on the selection and choose Paste Special, then select Values, and click OK
4- Now select the range B2 through C52 (i.e. through the last cell)
5- Click Data > Sort, and uncheck the box 'My Data has Headers'
6- In the sort fields select column C , and Z to A, then click OK
7- This will bring up all the cells that have X's to the top
8- Select the cells that have X's together with their corresponding cells in column, and press Delete
Hope this is clear. Let me know if you have any questions
Excellent! Thanks again