PDA

View Full Version : Compare two sheets and exclude existing in the second sheet



YasserKhalil
03-14-2019, 05:44 PM
Hello everyone
I have two sheets sheet1 & sheet2 and I need to get the data from sheet1 only but with a criteria which is : the item should not be there in sheet2 .. So if the item was existing in sheet2, then to exclude it from the results
I have attached sample workbook but the real data is too large

Another point the key here is the name but I need flexible way to deal with two keys (e.g. name and email)
If possible I don't want using Dictionary .. Just arrays and collections

Thanks advanced for help

大灰狼1976
03-14-2019, 09:23 PM
Hi YasserKhalil!
Please refer to the attachment.

YasserKhalil
03-15-2019, 12:10 AM
That's perfect solution. Thank you very very much for awesome help