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.

Open a new data sheet and enter data similar to mine.

You can of course use one of your existing data sheets.

Select  the title cells (see picture).

Click the Data tab ...

... and click Filter button.

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) ...

... and select only London (see picture).

Click OK.

And now there are only rows with London displayed, just like I wanted to.

Let's bring back all the cities again.

Click City and (Select All) option.

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...

In the Custom AutoFilter window choose is greater than and enter 200.

Click OK.

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$?