Sorting or filtering data can be the answer for those trying to find out how to organize data in Google Sheets. Where Sorting or Filtering Data in Google Sheets Can Fall Short When you want to return to your filter view, go back to the drop down arrow and select the name of your filter (in this case, “Filter 1”). To close out of your filter view, click on the funnel once again so that it is deselected. Simply return to the funnel in the upper right and click on the drop down arrow where you’ll select “Save as filter view.”Ħ. You have the option to save any filter you create so that other collaborators can reuse it. Or, you could filter out products to see if they are more popular in certain states.ĥ. For example, if you had a list of products and the states they were purchased in, you may want to filter out certain states to see the product’s popularity by region. Of course, there’s also the option to simply filter out certain values. A conditional filter allows you to apply certain rules in this case we want to look at every donation amount above $75 so that we can analyze which donor has donated large amounts. In this case, we’re going to be applying a conditional filter. This will open up a pop-up window where we’ll decide how we want to filter the data. Click on the green funnel next to your column name.Ĥ. Now, the column(s) that you selected will be highlighted in green. ![]() In the upper right corner, click on the three dots and select the funnel “Create a filter.”ģ. Filtering protects the integrity of the data while allowing you to quickly find the insights that you need.ġ.Select the column or range of columns where you want to apply your filter.Ģ. It’s especially useful if you’re working on a shared document there may be different questions that you’re looking to answer about the data vs. Repeat until you’d selected all columns you’d like to sort.įiltering data in Google Sheets is a great way to highlight certain data while removing (without deleting) other data that you aren’t interested in. Click “Add another sort column” to add your second column.Select the first column that you’d like to sort and whether the values should be listed from high to low or low to high.To exclude the header row, we’ll check the box that says “Data has header row.”.Here’s more detailed instructions on how to sort data in multiple columns: Theoretically, we could also add a third column to be considered, such as the date of the donation, and should there be any repeat donors and repeat donation amounts, the date of donation would determine their order. Now, let’s watch how those donation amounts change once we apply our multi-column sorting logic:Īmelia’s name is still listed alphabetically, but her donations values have been reorganized to be listed from highest to lowest (Z → A). In the image below, we can see that donor Amelia made three donations in the month of September, but her donation amounts aren’t organized in any particular order. Setting that up in Google Sheets would look like this:īefore setting up this sorting logic, our “Names” column was sorted alphabetically, but there was no sorting preference for the coinciding donation amounts. For example, we could give our donor names first priority (sorted A → Z) and our donation amounts second priority (sorted Z → A.). Google Sheets also gives us the option to sort multiple columns at once. How to Sort Data in Google Sheets Across Multiple Columns If we select our column of donation amounts, we could choose to organize those amounts from high to low (Z → A) or low to high (A → Z). This same function also works with numbers. We’ll keep the “A → Z” option selected since we want the names organized in ascending alphabetical order. Under “Sort by,” we’ll select the “Name” column that we want to sort.To exclude the header row in our sort, we’ll check the box that says “Data has header row.”. ![]()
0 Comments
Leave a Reply. |