Hi,
I am looking to reference 2 sheets and want to eliminate duplicate entries. I have tried using =IF(B2=A:A,"DE DUPE","OK") however this only works if the entry in B2 appears in A2. If the entry in B2 appears in say A4 it wont pick it up as a duplicate. Any ideas?
Thanks in advance.
Hi
The simplest way is to just copy the two lists into one column and from the menu select the big list and choose Remove Duplicates.
Otherwise use
=MATCH(B2,Sheet2!A:A,False)
If a match exists it will return a number that tells you the row number where the match exists. Just filter the list for numbers (since these appear on the other list) select the roes and delete them.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi,
Thanks for your response. The reason why I wanted to use the =IF formula I put previously is so that I could easily sort by 'de dupe' and delete these rows.
Ideally I do not want to copy into a long list because these sheets have different categories and I would have to copy them back, any further suggestions?
Last edited by marcbarnett; 01-27-2015 at 06:12 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks