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 th...
=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