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