SOLVED

New Contributor

# 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.

4 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Removing duplicate accounts listed in one sheet from another sheet

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

# Re: Removing duplicate accounts listed in one sheet from another sheet

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

# Re: Removing duplicate accounts listed in one sheet from another sheet

``=IF(ISNA(MATCH('First Sheet'!A2,'Second Sheet'!\$A\$2:\$A\$20,0)),A2,"")``

You can try this formula for unsorted random account numbers.

First Sheet:

Second Sheet:

# Re: Removing duplicate accounts listed in one sheet from another sheet

Take it back I expanded your formula to cover all of the second sheet numbers and it works- thanks