flammabubble
New Member
- Joined
- Aug 19, 2015
- Messages
- 25
So I've got a spreadsheet for my football team which shows stats for the players over the season. I've recently started noting what positions people play, and I want to be able to filter the stats by the position. The challenge is that some people play multiple positions over the course of a match, so I've ended up with several columns for the position played.
The first picture is some test data which I've simplified, and I've also attached the output sheet where you're able to see the grouped stats and the formula I'm using for filtering by individual columns (which is stupidly long, but it does work).
As you can see, if I put "Primary" and "LB", it correctly pulls 6 matches for Alex and 0 for Tim. What I want is to also be able to select "Any" and LM, and it to return results for the 3 games Alex played at LM which are across the Primary/Secondary/Tertiary columns. I was messing around trying to vstack the columns together but it didn't seem to like it, so I wonder whether this isn't something the filter function can acually do.
The first picture is some test data which I've simplified, and I've also attached the output sheet where you're able to see the grouped stats and the formula I'm using for filtering by individual columns (which is stupidly long, but it does work).
As you can see, if I put "Primary" and "LB", it correctly pulls 6 matches for Alex and 0 for Tim. What I want is to also be able to select "Any" and LM, and it to return results for the 3 games Alex played at LM which are across the Primary/Secondary/Tertiary columns. I was messing around trying to vstack the columns together but it didn't seem to like it, so I wonder whether this isn't something the filter function can acually do.
