Filtering Duplicates from One Sheet to the Next

Hi @techstackmatt,

Instead of using a route/filter, a better approach would be to use “filter in Search Rows”, as it only returns a result if there’s an exact match and otherwise, it comes back empty. (attached screenshot)

From there, you can route based on the “Total Number of Bundles”:

  • If 1 match is found (i.e., the email exists in “Master Leads”), you can skip or update accordingly.
  • If no match is found, go ahead and create the entry in both “Master Leads” and “Ready Leads”.

If this helps, please consider marking it as the solution :blush:

2 Likes