How To Use FILTER Function In Google Sheets

Here I’ve created a FILTER function in Google Sheets, that allows me to find Pokémon from generation 1 based on their type and stat points. The FILTER function is the main trick I use to do this and here is how it works.
The filter function can be used in Google Sheets to select specific data from a range based on one or multiple criteria, chosen by the user. Let’s use it on the Pokémon data to see it in action.
To use it, simply type =FILTER() and choose the range we want to filter from. In our case, this is ALL of the Pokémon stats apart from the headings. Then create the criteria according to which you want to filter the selected data. Let's say we want to find some fast Pokémon, so we write J2:J152≥100 and voila! Now the filter only returns Pokémon with 100 or greater in speed!
But hang on Lucas, I hear you screaming, how do I create a dynamic filter like the one you showed me in the beginning. Don't worry my friend! Simply replace the value in the criteria, in this case 100, with the cell where you want to enter the criteria threshold. Now you can easily filter for Pokémon that have a speed equal to or greater than the threshold set in the cell.
Then, to add multiple filters, simply extend the formula to include more criteria specified by you.
Now, if you're curious how to format the rows of each Pokemon based on each type like I did in my example in the beginning, simply click this video to find out! See you in there!

[@LucasLearnz]

What's your favourite function in Google Sheets or Excel?