|
|
|
|
|
Filtering data in Microsoft Excel
One of the more useful functions in Excel, which you can use to filter and display only the data you are interested in.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Open a new data sheet and enter data similar to mine.
You can of course use one of your existing data sheets.
|
|
| |
2.
|
|
|
Select the title cells (see picture).
|
|
| |
3.
|
|
|
Click the Data tab ...
|
|
| |
4.
|
|
|
... and click Filter button.
|
|
| |
5.
|
|
|
Excel created the filters automatically for each column automatically.
Let's check out how this thing works.
I want to display data only for London, so I need to click City (see picture) ...
|
|
| |
6.
|
|
|
... and select only London (see picture).
Click OK.
|
|
| |
7.
|
|
|
And now there are only rows with London displayed, just like I wanted to.
|
|
| |
8.
|
|
|
Let's bring back all the cities again.
Click City and (Select All) option.
|
|
| |
9.
|
|
|
Now let's do something else, I want to display only the rows where the costs are larger then 200$.
I need to click the Cost filter, Number Filters and choose Greater Than...
|
|
| |
10.
|
|
|
In the Custom AutoFilter window choose is greater than and enter 200.
Click OK.
|
|
| |
11.
|
|
|
Now I can only see the rows where the Cost is larger than 200$.
Would you know how to display only the people who live in London and their costs are greater then 200$?
|
|
|
 |
|
 |
|
 |
|
|
