Filter Function over multiple columns.

[flammabubble]

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.

 

[Cubist]

With sheets, can't use XL2BB so hope this helps.

flammabubble.xlsx

docs.google.com

 

[flammabubble]

With sheets, can't use XL2BB so hope this helps.
View attachment 111605

flammabubble.xlsx

docs.google.com

Hey, thanks so much for the reply! I've just tested this and it works for choosing Primary/Secondary/Tertiary but doesn't work if I want to look at all of them at once which is ultimately the goal. I can see you've used Match to decide which column to look at, is there a way to have a it check all of them?

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Countif with same criteria in multiple columns [SOLVED]

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...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[flammabubble]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Countif with same criteria in multiple columns [SOLVED]

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...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Apologies I just found out about that on the other forum too. Just confirming it's only been posted to Countif with same criteria in multiple columns and Countif result with same criteria in multiple columns aside from here.

 

[flammabubble]

Update - solved on Countif with same criteria in multiple columns [SOLVED]