Filter with condition in Excel

For example, in the table below, I want to see only those records where Q4-2016 Sales figures are less than the $3'900 target that I set.

excel filter with condition

To do it in Excel, here is the answer:

a) Click on any cell within the data Table. Under "Data" click on "Filter" to turn ON filter.

excel filter with condition

b) A "Down Arrow" button appears in all column headers. Click on the Q4-2016 Column down arrow. Click on Number Filters -> Less Than.

excel filter with condition

c) In the "Custom AutoFilter" dialog box that appears, set the rule as required - in this case, it is less than $3'900. Click OK.

excel filter with condition

d) Table is filtered to show only those records where Q4-2016 Sales figures are less than the $3'900 target.

excel filter with condition

e) To clear the filter, under "Data" click on "Clear" in "Sort & Filter" section as shown below..

excel filter with condition

f) The entire Table is shown as below.

excel filter with condition

 

You can find similar Excel Questions and Answer hereunder

1) How can I find the slab in which a given value fits?

2) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

3) Is there a way to get a log value of a number using Excel?

4) How can I set the Source Data of charts using VBA?

5) Vlookup to return max value from multiple hits in Excel

6) Given a raw data Table, how can I find the value of a field for a specific value of another field?

7) How can I fill a series of data automatically?

8) Tables in Excel VBA. How you can create table in VBA and work with them with macros

9) How can I identify all cells with Data Validation in my WorkSheet?

10) How do I find the median salary of employees with the same skillset in my Organization?

 

Here the previous and next chapter