How to Use Filters to Sort Data in Google Sheets

Sdílet
Vložit
  • čas přidán 7. 06. 2024
  • Adding filters to a range of data in Google Sheets is extremely easy and I have my trusty Pokémon stats to demonstrate how it works.
    Simply select the range you want to sort and click the filter icon in the top right corner. This allows us you to sort data in ascending (A-Z) or descending order (Z-A). In a good 90% of cases this will get the job done.
    However, maybe you want to filter out data based on a specific condition. Let’s say, we’re only interested in really strong Pokémon, so we want to filter out all Pokémon that have less than 525 in total stat points.
    To do so, simply click the filter icon on the top cell of the column of interest, then “Filter by condition” and “Greater than or equal to” and fill in 525. Now, only Pokémon with total stat points that are 525 or greater show up!

Komentáře •