Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Numbers provides a number of tools to help you reorganize data in a table. Let's check out the Sorting and Filtering options available in Numbers '09 using our 2006-2008 Sales Data. Now the first step is to select the table. To do that, you can click anywhere in the table itself or select it from the Sheets pane. You will notice this table has already been organized using Categories. But what if we wanted to view listings of Condos only in a particular price range and we wanted to view the results in ascending or descending order? No problem. With the table selected, click the Reorganize button. From here, you will notice two additional sections aside from Categories for Filtering and Sorting.
We will start with Filtering. To show Condos only, we need to choose the Type column and have it display Condo. So in the Filter section, click the button currently showing Choose a column and select Type. Next for the criteria, we want it to be Condo so IS, which is the default, is perfect. In the empty field, we'll type condo. This is case insensitive. Now, if we wanted to add an additional filter criteria for that price range, we click the plus sign. Instantaneously, you will notice the table is updated to display only Condos in the Type column.
Let's add some additional criteria. This time we are going to select the Price. For the criteria, we could choose to display values greater than and add additional criteria to display values that are less than, but in this case it's easier to choose the is between option. This gives us two fields where we can type the low end and the high end of our range. Let's type in 400000 and in the upper range you can tab or click and type 550000.
Now before we actually display the results, all of our results will automatically be sorted by Address in descending order. To display the lower values in the Price column then the higher ones as we move down, we'll change the Sort criteria as well. First, we'll change the column from Address to Price. Next, we'll choose ascending and we do want to sort the entire table. This is being updated as we make our selections. But because of the Categories, we are going to see the Sorting take place in each category and then start over for the next category.
If Categories are not important, we can deselect the Categories check box. This will display all of our results. Check the Price column in ascending order for Condos only. Notice the price range as well is between 400000 and 550000. So thanks to the Reorganize window, we have the ability to view only the data we need, sorted the way we want.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70013 Viewers
80 Video lessons · 127415 Viewers
52 Video lessons · 62362 Viewers
59 Video lessons · 48064 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.