Filter Data Based on Cell Value With Multiple Criteria in Excel Office 365!!
Tags: filterdatabasedoncel, kutoolsexceltutorial, kutools
Published: 2020-11-27 09:09:39

---
title: Filter Data Based on Cell Value With Multiple Criteria in Excel Office 365!!
published: true
date: 2020-11-26 07:27:37 UTC
tags: FilterDataBasedonCel,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/filter-data-based-on-cell-value-with-multiple-criteria-in-excel-office-365/
---

In this article, we are going to see how to **Filter Data Based on Cell Value With Multiple Criteria in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Filter Data Based on Cell Value with Criteria:

To filter data based on cell value with one criterion, do as follows.

- Let’s consider the below **example data** , we are going to filter it with the help of the **Super Filter** feature of **Kutools.**

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-data-2.png)<figcaption id="caption-attachment-18156">Example data</figcaption>

- In this example, we will filter data based on the **product = Apple**.
- Go to the **Kutools Plus Tab, select** the **Super Filter** option.

![Select the Super Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Super-Filter-option.png)<figcaption id="caption-attachment-18157">Select the Super Filter option</figcaption>

- It will open the **Super Filter pane** on the right side of the worksheet.
- First, you need to **select** the **Specified checkbox.**
- Then, **select** the **range** that you want to filter using the browse button.
- **Relationship drop-down list –** You need to **choose** the **OR** of **AND** option.
- **Relationship in Group – ** You can select the group relationship using this drop-down list.

![Select the OR option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-OR-option.png)<figcaption id="caption-attachment-18158">Select the OR option</figcaption>

- Then, you need to **click** the **horizontal line** adjacent to the relationship **AND.** It will display some condition boxes, you need to select the criteria as you need.
- Then, you need to **enter** the **condition** that you want to use and **click** the **OK** button to add the condition.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-11.png)<figcaption id="caption-attachment-18159">Click the OK button</figcaption>

- Finally, you need to **click** the **Filter** button.

![Click Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-Filter-option.png)<figcaption id="caption-attachment-18160">Click Filter option</figcaption>

- You can get the filtered result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-23.png)<figcaption id="caption-attachment-18163">Result</figcaption>

## Steps to Filter Data Based on Cell Value with Multiple Criteria:

Here, we are going to see how to filter data based on the following criteria.

**Criteria 1** : Product = Apple and Country = US

**Criteria 2:** Product = Grape and Quantity>30 

The **relationship** between these two criteria is **OR**.

- The following screenshot has shown in the example range.

![Sample data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-45.png)<figcaption id="caption-attachment-18164">Sample data</figcaption>

- Now, you need to follow the below steps.
- On the **Kutools Plus Tab, select** the **Super Filter** option.

![Select the Super Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Super-Filter-option.png)<figcaption id="caption-attachment-18157">Select the Super Filter option</figcaption>

- It will open the **Super Filter pane** on the right side of the worksheet.
- **Relationship drop-down list –** You need to **choose** the **OR** option.
- Then, you can create the criteria as you need. **Click Add Filter** or **Adding** button to add a new condition group.
- Then, **click** the **Filter** option to filter the data.

![Super Filter pane](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-44.png)<figcaption id="caption-attachment-18167">Super Filter pane</figcaption>

- You will get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-42.png)<figcaption id="caption-attachment-18168">Output</figcaption>

## Filter Data Based on Year/Month/Day/Week/Quarter:

If you want to filter rows based on year, month, day, week, or a quarter of the date, use the **Super Filter** function to complete the task.

- For example, we consider the below data given in the image.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-38.png)<figcaption id="caption-attachment-18169">Example data</figcaption>

- On the **Kutools Plus Tab, select** the **Super Filter** option.

![Select the Super Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Super-Filter-option.png)<figcaption id="caption-attachment-18157">Select the Super Filter option</figcaption>

- It will display the **Super Filter pane** on the right side of the worksheet.
- First, you need to **select** the **Specified checkbox.**
- Then, **select** the **range** that you want to filter using the browse button.
- **Relationship drop-down list –** You need to **choose** the **OR** or **AND** option.
- **Relationship in Group – ** You can select the group relationship using this drop-down list.
- Then, you need to **click** the **horizontal line** adjacent to the relationship **AND.** It will display some condition boxes, you need to select the criteria as you need.
- Then, you need to **enter** the **condition** that you want to use and **click** the **OK** button to add the condition.

![Super Filter pane](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-33.png)<figcaption id="caption-attachment-18172">Super Filter pane</figcaption>

- At last, **click** the **Filter** button and the rows which **date in quarter 4** have been filtered out as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-31.png)<figcaption id="caption-attachment-18173">Output</figcaption>

- You can filter the data by month, year, day, week by applying the same steps.

## Steps to Filter Data Based on Text Length/Number of Characters:

To filter data based on the text length/number of characters in Excel, follow the below steps.

- You need to activate the worksheet contains data that you want to filter.
- Refer to the below example worksheet with data.

![Sample data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-29.png)<figcaption id="caption-attachment-18174">Sample data</figcaption>

- Go to the **Kutools Plus Tab, select** the **Super Filter** option.

![Select the Super Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Super-Filter-option.png)<figcaption id="caption-attachment-18157">Select the Super Filter option</figcaption>

- It will show the **Super Filter Dialog Box**.
- Then, **select** the **range** that you want to filter using the browse button.
- **Relationship drop-down list –** You need to **choose** the **OR** of **AND** option.
- **Relationship in Group – ** You can select the group relationship using this drop-down list.
- Then, you need to **click** the **horizontal line** adjacent to the relationship **AND.** It will display some condition boxes, you need to select the criteria as you need.
- Then, you need to **enter** the **condition** that you want to use and **click** the **OK** button to add the condition.
- Next, you need to **click** the **Filter** button.

![Super Filter Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-26.png)<figcaption id="caption-attachment-18175">Super Filter Dialog Box</figcaption>

- You can see the rows which **text length is greater than 10 characters** have been filtered as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-23.png)<figcaption id="caption-attachment-18176">Output</figcaption>

## Filter Cell Text with Case Sensitive:

If you want to filter the rows in which the text string is only uppercase or lowercase, then follow the below instructions.

- Let’s consider the below example data.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-20.png)<figcaption id="caption-attachment-18178">Example</figcaption>

- On the **Kutools Plus Tab, select** the **Super Filter ** option.

![Select the Super Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Super-Filter-option.png)<figcaption id="caption-attachment-18157">Select the Super Filter option</figcaption>

- It will show the **Super Filter Dialog Box**.
- Then, **select** the **range** that you want to filter using the browse button.
- Then, you need to **click** the **horizontal line** adjacent to the relationship **AND.**
- You need to **choose** the **column name** that you want to filter from the **first** & **second** drop-down lists and **select** the **text format.**
- Then, you need to **choose** the **criteria** from the **third drop-down** list.
- Then, you need to **select** the **uppercase/lowercase** text option to filter them (we choose **UPPERCASE).**
- Hit the **OK** button and **click** the **Filter** option.

![Click Filter button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-14.png)<figcaption id="caption-attachment-18181">Click Filter button</figcaption>

- You will get the filtered result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-13.png)<figcaption id="caption-attachment-18182">Result</figcaption>

## Steps to Filter Cell Values with All Errors or One Specific Error:

To filter cell values with all errors or one specific error from the range in Excel, do as follows.

- You need to **select the data** that you want to filter.

![Input](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-10.png)<figcaption id="caption-attachment-18183">Input</figcaption>

- On the **Kutools Plus Tab, select** the **Super Filter** option.

![Select the Super Filter option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Super-Filter-option.png)<figcaption id="caption-attachment-18157">Select the Super Filter option</figcaption>

- It will open the **Super Filter Dialog Box**.
- You need to **click** the **horizontal line** beside the relationship  **AND.**
- Then, **choose** the **column name** that you want to filter from the first drop-down list.
- You need to **select** the **error** that you want to filter from the second drop-down list.
- Then, **select** the **criteria** from the third drop-down list.
- Finally, you need to **specify one choice** you need and **hit** the **OK** button.

![Super Filter](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-10.png)<figcaption id="caption-attachment-18184">Super Filter</figcaption>

- Now, you need to **click** the **Filter** option to get the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-8.png)<figcaption id="caption-attachment-18185">Output</figcaption>

## Save Filter Criteria as Scenario for Using Next Time:

- **Click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-17.png) **button** to create a new filter settings scenario. If there are existing filter settings that are not saved, a dialog box will pop-out.

![Kutools for Excel prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/16-5.png)<figcaption id="caption-attachment-18186">Kutools for Excel prompt box</figcaption>

- You need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-super-filter-017.png) **button** to save your current filter settings. If the current filter settings are not saved before, a dialog box will display to name this new filter scenario.

![Save](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/17-4.png)<figcaption id="caption-attachment-18187">Save Filter</figcaption>

- **Click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-super-filter-018.png) **button** to save the current filter settings to a new filter scenario.
- You can **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-20.png) **button** to close the current filter scenario.
- **Click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-21.png) button to display the **Open saved filter settings scenario** dialog, then select a scenario in the right pane of the dialog to open it.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/18-4.png)<figcaption id="caption-attachment-18188">Click OK button</figcaption>

- You need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-super-filter-019.png) to open the Manage filter settings scenarios dialog box. You can **manage the scenarios** of each scenario folder.

![manage the scenarios](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/19-4.png)<figcaption id="caption-attachment-18189">manage the scenarios</figcaption>

## A Brief Summary:

In this article, you will easily understand the steps to **Filter Data Based on Cell Value With Multiple Criteria in Excel Office 365** using **Kutools.** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Filter Cells by Background Color in Excel 365?](https://geekexcel.com/how-to-filter-cells-by-background-color-in-excel-365/)
- [Import Data from Another Worksheet or Text Files in Excel Office 365!!](https://geekexcel.com/import-data-from-another-worksheet-or-text-files-in-excel-office-365/)