Filter Data Based on Criteria in Selected Cell

How to filter data quickly and easily based on different criteria in the selected cell. Watch the video below:

Filter Data Based on 5 Criteria in Selected Cell

Let’s learn how to filter data based on 5 criteria in the selected cell as shown below. The first action is to write the criteria below our data. Next we right click on the entered data, select filter from the appearing menu and select an appropriate criteria as shown in the image:

How to filter data quickly and easily based on different criteria in the selected cell.
How to filter data based on different criteria in the selected cell
  • Filter data based on the cell value like ‘Personal Care’ or ‘>=1150000’ as shown in the images below:
Filter data based on text value in selected cell
Filter data based on text value in selected cell
Filter data based on numerical value in selected cell
Filter Data Based on Numerical Value in Selected Cell
  • Filter by selected cell’s fill color as demonstrated in the image below:
Fiter data based on selected cell's fill color
Filter Data Based on Selected Cell’s Fill Color
  • Filter data based on cell’s font color as shown in the image below:
Filter data based on cell's font color
Filter Data Based on Cell’s Font Color
  • Filter Data by selected Cell’s Icon as demonstrated in the image below:
Filter data by selected cell's icon
Filter Data by selected cell’s icon

As you can experience we now have another method based on the selected cell’s value to filter and analyze our data quickly and elegantly.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.