filter data from columns

[peter_swe]

Dear members!
Do not know if I type in the correct forum / subforum, if not, I ask the admin to please move the post to the right forum.

I would like to know/learn how to do this with Excel:
I´ve a sheet with several columns. I want to be able filter several columns:
a) I want to see all games played in a gym with both referees each game
b) I want to see all games played in a gym on a date with both referees each game
c) most importantly I want to be able filter a special referee's all colleagues. That special referees name can appear in both column ( referee 1 and referee 2)
Is this even possible to do with excel?

Thanks in advance for Your help :-)
Best regards
Peter

[Shareez Saleem]

You can use advance filter or pivot table.


Advance filter?

Insert 2 rows above the existing table, the first row can be the same as your existing table's titls, i.e Group, Home Team etc.

1. Go to Data Tab, Select Advance Filter.
2. Select List Range as the existing table.
3. Criteria as 2 new rows added above the table.
4. Ok.
5. Now give one or more criterias on the newly added 2nd row.
6.Click again the advance filter.
7. You can see the filtered table below.

Hope this helps.

You can also use Pivot Table.

[peter_swe]

Thanks Shareez!

• I inserted two rows - copied the existing row, and added one empty
  • Selected Advance filter and Selected Range

Now I I got stuck with the criteria....
Can U please give me a quick exemple?

[Shareez Saleem]

Criteria- Select the newly added 2 rows.
Then click Ok.

Get back to sheet, give as many as criteria you want (for example,Gym, referee1, referee 1 etc.)
Do a advance filter again.
Now you can see the filtered data below.

To get back to the original, please use "clear" under the Data Tab.

Attached sheet FYR.

[peter_swe]

Maybe I´m stupid, but I don´t understand how this works :-(
The filter is easy to understand:
I "click" for a special referee and get all games for that referee
I "click" for a special date and get a list of games played that day
I "click" for a special gym and get all games played in that gym
And in all cases if I click on all I got the whole schedule.
But how can I do the following to:
if I "click" for a special referee, I get a list of all games for that referee AND his colleagues (please note the this referee can appear in both columnas)
I I would like to be able to do the rest to....

[Shareez Saleem]

Hi Peter,

Please refer the attached.

You can give the referee name and Name 2 in newly added rows(above the existing table).

[peter_swe]

Tahnks Sharez! but it´s still not what I´m looking for.
Maybee time for me to learn Pivot table

[Shareez Saleem]

All the best Peter.

Pivot is so simple.

Just have a look at the attached file.

You can filter the date using "Slicer" option in Pivot Table/Chart.

Once you filtered, just click on any of the value in Pivot Table, it will take you to a new sheet where you need the most filtered data.

You can add as many as slicers you want.

Kindly close this Thread.

[peter_swe]

Excuse my insistence, but have a supplementary question: is there a way to filter a referee who is present in both the columns referee 1 and referee 2.
I'm not looking for a pivot, but Excel's built-in filter

thanks in advance
Peter

english.xlsx