How to filter data quickly and easily based on different criteria in the selected cell. Watch the video below:
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:
- Filter data based on the cell value like ‘Personal Care’ or ‘>=1150000’ as shown in the images below:
- Filter by selected cell’s fill color as demonstrated in the image below:
- Filter data based on cell’s font color as shown in the image below:
- Filter Data by selected Cell’s Icon as demonstrated in the image below:
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.