mercredi 24 juin 2020

Filtering multiple columns in Google Sheets

I'm trying to filter multiple rows and columns in Google Sheets and show only the cells that match the value that I want, but so far I didn't have success.

Here goes a link with the raw data and the expected output that I need. https://docs.google.com/spreadsheets/d/1355FJBYlzlU1RajWZ1Cj1qhXkRrU4QYegeQ4UzBeE3I/edit?usp=sharing

In this example, I wanna filter by activity and show only the days that I have a "Cycling" class, for instance. The filter needs to be a sort of dropdown since more people will be using it.

I tried to use the slicer feature, but it allows me to filter just 1 column and not multiple.

Any idea on how to make it?

Aucun commentaire:

Enregistrer un commentaire