hi, I understand the logic, but I couldn’t make it work. anyone mind helping?
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)