8 Replies Latest reply on Jun 24, 2016 6:56 AM by Michael Lahey

    Filter 1 Column based on data from different column

    Michael Lahey

      Hi All,

      I have been trying to figure this out myself for a few hours and can't seem to get it done correctly. I would like to exclude data in the ID column based on whether or not it has a Cancel task in the second column. Is there something with creating a set of both columns that could help? The data I'm working with is also tough to deal with since it isn't completely uniform (so I can't just do a min or max).

       

      Any help would be appreciated, workbook attached.

       

      Thanks in advance!