Difficulty:IntermediateLength:MediumLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng ViệtData is taking over the world, And often, we just have so much of it that it"s a challenge to find meaning in it to understand the situation at hand" /> Difficulty:IntermediateLength:MediumLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng ViệtData is taking over the world, And often, we just have so much of it that it"s a challenge to find meaning in it to understand the situation at hand" />

Cách tạo bộ lọc trong google sheet

post-promotion-placement#checkSidebarAdDisplayCondition" data-controller="sticky-ad post-promotion-placement">
Difficulty:IntermediateLength:MediumLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng Việt

Data is taking over the world. And often, we just have sầu so much of it that it"s a challenge to find meaning in it to lớn understand the situation at hvà.

You watching: Cách tạo bộ lọc trong google sheet

Spreadsheets are one of the best ways to analyze data sets for their structure & ease of use. But many data sets are just too big to easily get your hands around. You need ways of finding the data you"re looking for & narrowing down the dataset.

In this tutorial, you"ll learn to apply a Google Sheets filter to limit the data you"re seeing. Then, you"ll learn the secrets of using the Google Sheets sort function khổng lồ put data in the sequence you need lớn see it in.

*
*
*
In the example data included with this tutorial, each row is a "record" of an employee we"re recruiting, và each column has an attribute that describes that candidate.

When you sort that data, it"s crucial that it stays grouped together properly. If you only sort the column that contains the amount of the sale, suddenly you"ve got mismatches in your data! A $100 sale is now assigned khổng lồ the wrong customer, for example. 

This is why sorting data properly is so crucial. Let"s walk through a few examples below. 

How to Sort Data in Google Sheets

One of the most common Google Sheets sorting tasks is lớn sort your data from A-Z. It usually makes reading the data easier, và it also simplifies finding specific rows that you know you"re looking for.

Before I start to lớn vày any sorting, my first step is khổng lồ always highlight the entire table. This minimizes the chances that we"ll accidentally sort by the wrong column, or only sort part of the data.

Once you"ve sầu got the entire mix of data highlighted, go khổng lồ the Data > Sort Range thực đơn option, as you can see in the screenshot below.

*
*
*
Click add another sort column lớn give yourself multiple sort rules for your data.

Use these multi-màn chơi sorts khổng lồ really specify how the finished data should appear. You can add as many sort rules as you want to lớn get the data order just right.

3. Use Google Sheets Filters

While sorting changes the order và sequence of the data in a spreadsheet, filtering changes what data is currently visible in the spreadsheet. Let"s learn how khổng lồ apply Google Sheets filters so that we can narrow down the data that"s in view.

See more: Đồng Hồ Apple Watch Series 2 42Mm Mặt Nhôm, Dây Cao Su Màu Đen

To start adding filters, highlight your data table. Then, go to Data > Create a Filter on the Sheets thực đơn.

Now that you"ve sầu turned on filtering, you"ll see a small inhỏ on the upper right corner of the header. Click on that inhỏ, and then you"ll see a danh sách of values that are in that column in the pop-up menu as you can see in the screenshot below.

*
*
*
Clichồng on the icon in the column header to choose what you want to limit your data to lớn.

On this pop-up, simply toggle off or on the criteria that you want your data lớn meet. When you press OK, the spreadsheet will be narrowed down to lớn only show data that matches those Google Sheets filter rules.

Much like sorting, you can staông xã multiple levels of filtering. In the example below, I added a filter lớn the Salary Grade column.

*
*
*

This is a picture-perfect example of how useful filtering can be to lớn make sense of a data mix. By combining an "interest" filter with a "salary grade" filter, I"ve got a refined danh mục of two candidates out of a possible 100.

It"s an important distinction to rethành viên that filtering data doesn"t delete or remove sầu data. It"s still behind the scenes, waiting lớn show again as you change the filtering settings.

Watch Out for "Missing" Data

Here"s something to think about while you"re working with filtered data: you need to be careful about what data you leave behind the scenes. I can"t tell you how many times I"ve sầu been working in a spreadsheet và missed out on the fact that data was "missing" because it was removed from the Google Sheets filter view.

I always keep my eye out for two things if the data isn"t making sense:

The filter ibé at the top of the columnThe row numbers in Sheets on the left side
*
*
*
Notice in this screenshot that the row numbers (outside of the spreadsheet at the far left) are no longer in sequence, as well as the filtering inhỏ above column F.

See more: Cách Gõ Tiếng Việt Có Dấu Trên Điện Thoại Android, Hướng Dẫn Cách Gõ Tiếng Việt Có Dấu Trên

These two tricks are perfect for ensuring that you never "miss" data in the spreadsheet.

Recap & Keep Learning

Filtering and sorting are crucial tools for narrowing & selecting data. Chechồng out the tutorials below for more tips on using Sheets for data đánh giá & analysis. 

You"ve sầu just learned how lớn use filter và sort in Google Sheets. How do you handle working through huge data sets? Do you use the Google Sheets sort & Google Sheets filter tools to lớn narrow down your data sets, or vày you use other analytical tools?