hi, I understand the logic, but I couldn’t make it work. anyone mind helping?
Appreciate!!!
__
img1: special request
img2: main report
img3: wanted result
__
from img1 filter those with request contain “email”
then compare “donor id” from img1 with “dnr_id” from img2
finally write it into a new excel ‘rptDup’. the result should be like img3
__
filterDatatable.zip (26.3 KB)