5 Replies Latest reply on Jun 14, 2019 1:24 PM by Ken Flerlage

    Question about Sets

    Phil Simon

      I'm noodling with sets for the first time. It seems like they largely function as database views. I know how I'd do this with Access, SQL, and Excel, but I'm trying to avoid those.


      I'd like to use each set in the workbook as an 'AND' such that I only pull men who've won each of the four majors. (See the sets.) Jack and Tiger appear in all four because they won all four. Rory McIlroy wouldn't appear in the final set because he's yet to win the Maters.


      I created four sets. The in/out filter is not working—probably because I don't understand what it's trying to do.


      Thanks in advance. I suspect that I'll say this after someone posts how to do this: