- \n
- Not Equal to in Excel<\/strong><\/a><\/li>\n
- How to Put \u201cNot Equal To\u201d in Excel<\/strong><\/a>\n
- \n
- Example 1 \u2013 Implementing the “Not Equal To” Operator in Excel<\/strong><\/li>\n
- Example 2 \u2013 Using String<\/strong><\/li>\n
- Example 3 \u2013 Using IF Statement<\/strong><\/li>\n
- Example 4 \u2013 Using the COUNTIF Function<\/strong><\/li>\n<\/ul>\n<\/li>\n
- What You Should Know About Not Equal To in Excel<\/strong><\/a><\/li>\n<\/ol>\n
1. Not Equal To in Excel:<\/strong><\/h2>\n
A logical operator in Excel called “not equal to” is used to compare two numerical or textual values. It is written using a pair of angle brackets that point away from one another (much like >). The “not equal to” Excel symbol will result in either of the two possible Boolean values (true or false).<\/p>\n
- \n
- True signifies that the two values being compared are neither equal nor different.<\/li>\n
- False signifies that the two values being compared are identical or equal.<\/li>\n<\/ul>\n
For instance, “=10>5” yields “true” since the integers 10\u00a0and 5\u00a0are not equal to one another (ignore the double quotation marks).<\/p>\n
In the arguments of various Excel functions, the phrase “not equal to” is used. The “not equal to” operator is used to determine whether or not two values are different. However, this operator does not express the size of the difference.<\/p>\n
2. How to Put \u201cNot Equal To\u201d in Excel?<\/strong><\/h2>\n
Excel Not Equal To operator is quite intuitive and straightforward to use. Let’s look at some instances to better grasp how Excel’s \u201cNot Equal To\u201d Operator functions.<\/p>\n
- \n
- \n
Example 1 \u2013 Implementing the “Not Equal To ” Operator in Excel:<\/strong><\/h3>\n<\/li>\n<\/ul>\n
We’ll demonstrate how to use the Excel Not Equal To the logical operation in this example.<\/p>\n
Suppose you run a small business that sells fruits and vegetables. You want to keep track of your daily sales and inventory using an Excel sheet. Below is a table that shows the sales and inventory of fruits and vegetables for a day:<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-1.png\")
<\/p>\nTo check if the sales and inventory of each item match, you can use the Not Equal To in Excel. In this case, you want to check if the sales of an item are not equal to its inventory.<\/p>\n
The steps to check if the sales of an item are not equal to its inventory using “Not Equal To” operator in Excel are described below:<\/strong><\/p>\n
Step 1:<\/strong> Create a new column named, Not Equal To “<>”.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-2.png\")
<\/p>\nStep 2:<\/strong> Type the following formula in cell D2.<\/p>\n
=B2<>C2<\/strong><\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-3.png\")
<\/p>\nSo, as we can see in the above screenshot, we applied the formula as =B2<>C2 here, we can see that in the\u00a0 B2 cell Sales is 20, and in C2 cell Inventory is 30, so the values are not match.<\/p>\n
Excel will check if B3 values are not equal to C3, then it returns TRUE or else it will return FALSE.<\/p>\n
Step 3:<\/strong> Press Enter key on your keyboard to apply the formula.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-4.png\")
<\/p>\nHere in the above screenshot, we can see that Sales is not equal to Inventory, so we will get the output as TRUE, which is shown in the below screenshot.<\/p>\n
Step 4:<\/strong> Drag down the formula for the next cell. So, the output will be as below:<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-5.png\")
<\/p>\nWe can see that the formula =B3<>C3; in this case, Sales is equal to Inventory. So, excel will return the output as FALSE, as shown above.<\/p>\n
Example 2 \u2013 Using String:<\/strong><\/h3>\n
We’ll explore how the Excel not equal to operator behaves with strings in this example. Take a look at the example below, which features the book titles of two different writers.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-6.png\")
<\/p>\nBy doing the procedures listed below, we can verify that the book names of Writers 1 and 2 are identical:<\/strong><\/p>\n
Step 1:<\/strong> First, create a new column called “Does book name different?”.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-7.png\")
<\/p>\nStep 2:<\/strong> Type the following formula in cell D2.<\/p>\n
=A2<>B2<\/strong><\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-8.png\")
<\/p>\nSo, the above formula will check for A2 book name is not equal to B2 book name if it is not equal, it will return FALSE or else it will return TRUE.<\/p>\n
Step 3:<\/strong> Press Enter key on your keyboard to apply the formula.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-9.png\")
<\/p>\nWe can see that both the book names are the different and it will return the outcome as TRUE which is shown in the above screenshot.<\/p>\n
Step 4:<\/strong> Drag down the formula for the next cell. So, the output will be as below:<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-10.png\")
<\/p>\nAs =A3<>B3, where we can see the A3 book name is equal to the B3 book name, so we will get the output as FALSE which is shown as the output in the above screenshot.<\/p>\n
- \n
- \n
Example 3 \u2013 Using IF Statement:<\/strong><\/h3>\n<\/li>\n<\/ul>\n
We’ll examine how to use the if statement in the Not Equal To operator in this Excel example.<\/p>\n
Suppose you have a list of job applicants and you want to filter out all applicants who do not have experience working in a specific industry.<\/p>\n
The following example table is shown below:<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-11.png\")
<\/p>\nThe steps to filter out all applicants who do not have experience in the IT industry using \u201cNot Equal To\u201d operator with IF statement in Excel are described below:<\/strong><\/p>\n
Step 1:<\/strong> Create a new column as Filter Status.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-12.png\")
<\/p>\nStep 2:<\/strong> Apply the following formula in cell C2.<\/p>\n
=IF(B2<>”IT”,”Remove”,”Keep”)<\/strong><\/p>\n
This formula checks if the value in column B (Industry Experience) is not equal to “IT” for each row. If the applicant does not have IT experience, it returns the text “Remove”. Otherwise, it returns “Keep”. The resulting table would look like this:<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-13.png\")
<\/p>\nAs you can see, using the “Not Equal To” operator in Excel has allowed us to quickly and easily filter out all applicants who do not have IT experience. By using this operator in your own data analysis tasks, you can similarly compare strings and spot patterns in your data that can help inform your decision-making.<\/p>\n
- \n
- \n
Example 4 \u2013 Using the COUNTIF Function:<\/strong><\/h3>\n<\/li>\n<\/ul>\n
We’ll explore how the COUNTIF Function operates in the Not Equal To operator in this Excel example.<\/p>\n
Take a look at the example below, which displays customer\u00a0feedback.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-14.png\")
<\/p>\nThe procedures listed below will help us determine how many consumers have sent poor\u00a0feedback:<\/strong><\/p>\n
Step 1: <\/strong>Add a new row with the title “Total Poor Feedback.”<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-15.png\")
<\/p>\nStep 2:<\/strong> Apply the COUNTIF formula as below:<\/p>\n
=COUNTIF(B2:B9,”<>Good”)<\/strong><\/p>\n
This formula uses the “Not Equal To” operator (“<>”) to check each value in the “Feedback” column (column B) and counts the number of values that are not equal to “Good”.<\/p>\n
![\"Not](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Check-Not-Equal-To-16.png\")
<\/p>\nAs you can see, by using the “Not Equal To” operator with the COUNTIF function, we were able to count the total number of poor feedbacks.<\/p>\n
3. What You Should Know About Not Equal To in Excel?<\/strong><\/h2>\n
- \n
- Logical operators are frequently employed in conditional formatting in Microsoft Excel, which will produce the best results.<\/li>\n
- The Not Equal To operator always needs two values to determine if a value is “TRUE” or “FALSE.”<\/li>\n<\/ul>\n
When employing the Not Equal To on Excel, be sure to provide the correct condition statement; otherwise, we will receive an incorrect result.<\/p>\n
Application of Not Equal To in Excel<\/h2>\n
- \n
- Data Filtering<\/strong>: Exclude specific values from datasets by using the “Not Equal To” operator in Excel filters, facilitating targeted data analysis.<\/li>\n
- Conditional Formatting<\/strong>: Apply conditional formatting rules to cells based on criteria where values are not equal to a specified reference, highlighting discrepancies or outliers.<\/li>\n
- Formula Criteria<\/strong>: Use the “Not Equal To” operator in Excel formulas to create conditions for calculations or logical tests, enabling dynamic data processing.<\/li>\n
- Data Validation<\/strong>: Set up data validation rules to restrict entries in cells where values are not equal to certain criteria, ensuring data integrity and consistency.<\/li>\n
- Comparative Analysis<\/strong>: Compare datasets or columns by filtering or highlighting rows where values are not equal, facilitating comparative analysis and identification of differences.<\/li>\n
- Error Identification<\/strong>: Identify errors or inconsistencies in datasets by applying filters or formulas to highlight cells where values are not equal to expected or reference values, aiding in data quality assessment.<\/li>\n<\/ul>\n
For ready-to-use Dashboard Templates:<\/strong><\/p>\n
- \n
- Financial Dashboards<\/a><\/li>\n
- Sales Dashboards<\/a><\/li>\n
- HR Dashboards<\/a><\/li>\n
- Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
Not Equal To in Excel provides a powerful tool for comparing values and identifying discrepancies within your data. Whether you’re filtering datasets, creating conditional formulas, or conducting data analysis, Not Equal To in Excel offers flexibility and precision in your comparisons. Say goodbye to manual sorting and filtering and hello to efficiency with this versatile …<\/p>\n
- Sales Dashboards<\/a><\/li>\n
- Conditional Formatting<\/strong>: Apply conditional formatting rules to cells based on criteria where values are not equal to a specified reference, highlighting discrepancies or outliers.<\/li>\n
- Data Filtering<\/strong>: Exclude specific values from datasets by using the “Not Equal To” operator in Excel filters, facilitating targeted data analysis.<\/li>\n
- \n
- \n
- \n
- Example 2 \u2013 Using String<\/strong><\/li>\n
- How to Put \u201cNot Equal To\u201d in Excel<\/strong><\/a>\n