Forum Discussion
Solved
Removing duplicate accounts listed in one sheet from another sheet
The first sheet that contains all account numbers used and a second sheet that includes specific account numbers. I want to be able to remove any account numbers that are in the Second Sheet from the First Sheet. I can do manual search on the First sheet but want to be able to do it all at once is possible.
=IF(ISNA(VLOOKUP(A4,$E$4:$E$22,1,FALSE)),A4,"")An easy approach could be this formula. After applying the formula you can copy column B and paste only values. Then you can delete column A.
=IF(ISNA(VLOOKUP(A4,$E$4:$E$22,1,FALSE)),A4,"")An easy approach could be this formula. After applying the formula you can copy column B and paste only values. Then you can delete column A.
- Thank you but unfortunately my list of account numbers do not line up so easily so the formula you propose does not solve my problem. The listings are random account numbers on each sheet
- Take it back I expanded your formula to cover all of the second sheet numbers and it works- thanks
