4 Replies Latest reply on Aug 22, 2018 3:06 PM by Char Miller

    Sets, filters or other options to keep some rows and not others

    Char Miller

      Hello -

       

      In the screenshot below, I want to divide this data into two sets: one set that includes all active IDs and one of the inactive IDs, and another set that includes the second inactive ID.

       

       

      This would be wonderfully easy if the data were such that I could filter on active/inactive, but because there are a few inactive IDs that need to be included, I can't do that. Is there a way to create a dynamic set from this data so that I don't have to manually sort it out? Or is there an option other than sets that I'm not thinking of? A way to manipulate the data?

       

      Workbook attached. Any help really appreciated!

       

      Cheers,

      Char