Hi all,
I have a worksheet with two lists on separate tabs... I need to get this list onto a third tab without duplicates... I also need it to be a formula or macro (not cut and paste) because it works off live data from my CRM system. I fundamentally understand how to do this but i can't seem to get it to work because the lists are formatted like this: Column A = Company, Column B = Contact...
I have attached an example of what i am talking about if this helps.
Fruit Companies Test.xlsx
The easiest way would to copy second list underneath the first and use Remove duplicates feature in excel located under Data tab.
Or use formula
=INDEX(A$2:A$17,MATCH(0,INDEX(COUNTIF(D$1:D1,A$2:A$17),,),))
Adjust ranages as needed.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you for your response!
The only issue with your answer is that the two lists are dynamic, so I can't copy and paste or manipulate anything on tab 1 or 2 because it will just cancel any amendments to the sheets when i hit refresh... if that makes sense?
The use the same formula like this
=IFERROR(INDEX('Clients A'!B$2:B$11,MATCH(0,INDEX(COUNTIF(B$1:B1,'Clients A'!B$2:B$11),,),)),IFERROR(INDEX('Clients B'!B$2:B$7,MATCH(0,INDEX(COUNTIF(B$1:B1,'Clients B'!B$2:B$7),,),)),""))
Updated sheet
Last edited by AlKey; 09-16-2014 at 09:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks