LinkBack URL
About LinkBacks
Alan L 185 
Hi
I want to compare two sets of data (see Before worksheet) and remove all the duplicates so that only the unique entries in both sets are left (see After worksheet).
Removing Duplicates
Hi
I want to compare two sets of data (see Before worksheet) and remove all the duplicates so that only the unique entries in both sets are left (see After worksheet).
hi Alan L 185. in the After sheet, use this array formula in A3:
Formula:
=IFERROR(INDEX(Before!A$3:A$19,SMALL(IF(COUNTIF(Before!$F$3:$F$20,Before!$A$3:$A$19)=0,ROW(Before!$A$3:$A$19)),ROWS(A$3:A3))-ROW(Before!$A$3)+1),"")
copy to column D. in F3, it's a slight change to:
Formula:=IFERROR(INDEX(Before!F$3:F$20,SMALL(IF(COUNTIF(Before!$A$3:$A$19,Before!$F$3:$F$20)=0,ROW(Before!$F$3:$F$20)),ROWS(F$3:F3))-ROW(Before!$F$3)+1),"")
copy to Column I
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Example.xlsx
Please see attached
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thanks benishiryo and RobertMika for your quick responses. I'll try it out on the actual data tomorrow and let you know how I get on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks