Custom Filter / Formula / Unique Tool based off criteria help

[dberroth]

Hello all, I've been beating my head on this for a week and just can't get all the way there. What I am trying to do below is first determine if there are two IDs that match AND has a Source 1 AND 2, if so I need to grab ALL those ID's that Match. You can see below the example. The first two columns are the input, the two columns on the right are the desired output. The above scenario is shown below, and as you can see below, the two bottom ID's that match, but there are not a Source 1 &2, so those are not included on the output. Is there a way to determine a match on ID AND determine if there is a source 1&2, if there is , then grab ALL ID's that fit that criteria.

I've tried Joins/Unique tool/etc, just can't get there.

[dberroth]

Hello and thanks for the reply. I was able to do a modification of what you provided to get this to work. I appreciate your help and getting me in the right direction!