Filter data, remove duplicate and extract certain data

hi guys, I have done filtering one of my request. but there are a few trickier requests left.


  1. read img1, compare and move the duplicate data to excel img5.
  2. read img2 and compare with img1, then compare img1 “donor ID” with img2 “dnr_id”.
    If img2 ID doesn’t exist in img1. remove and move it to img3 and add “doesn’t exist”.
  3. filter out the request “email” from img2, copy it to excel img4 and add request email. ~DONE
  4. filter out the request contain name and move it to excel img6.
    If request name doesn’t exist, remove and move it to img3 and add “doesn’t exist”.

btw. is there any method to make my sequence not so messy?


file included:
transfermail.zip (31.5 KB)