OR Function Archives

Partial Match with IF in Excel (4 Basic Operations)

Sep 23, 2021 Excel Formulas

IF is one of the most common functions in Excel. Depending on circumstances different logical operations can be performed through this function. We ...

How to Perform Partial Match String in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

Whenever you are handling a wide range of data in your worksheet, partial matching or fuzzy matching is an effective way to find your match quickly. ...

Find Matches or Duplicate Values in Excel (8 Ways)

Oct 26, 2021 Excel Basics

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How to Filter Multiple Columns Simultaneously in Excel (3 Ways)

Sep 22, 2021 Excel Basics

Filtering data is a great way to find information quickly especially when the worksheet contains a lot of input. When you filter a column then the ...

How to Filter Multiple Columns Simultaneously in Excel (3 Ways)

How to Use IF Function in Excel (8 Suitable Examples)

Sep 21, 2021 Excel Functions

In Microsoft Excel, the IF function is used to check if a condition is met and then the defined statements will be shown based on the given ...

How to Use NOT Function in Excel (With 8 Examples)

Sep 21, 2021 Excel Formulas

Basically, in Excel, the NOT function reverses the results of logical value. In situations where we need to know whether or not a given condition was ...

How to Use AND Function in Excel (5 Suitable Examples)

Sep 21, 2021 Excel Functions

In Microsoft Excel, AND is one of the most frequently used functions and the AND function is applied to check for logical tests under different ...

How to Use OR Function in Excel (4 Examples)

Sep 21, 2021 Excel Functions

There are a number of functions in Excel to perform various logical operations easily and swiftly. Today we are going to show you how to use a ...

Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

Sep 20, 2021 Data Analysis with Excel

In Microsoft Excel, using Advanced Filter with multiple criteria allows us to add different logics and functions to execute a wide range of ...

Excel If Statement with Multiple Conditions in Range (3 Suitable Cases)

Oct 27, 2021 Excel Formulas

Today I will be showing how you can use the IF statement with multiple conditions in any range in Excel. Download Practice Workbook Excel ...

Find Duplicates in Two Columns in Excel (6 Suitable Approaches)

Oct 26, 2021 Excel Formulas

Microsoft Excel has provided numerous methods to find duplicates in two or more columns. In this article, you'll learn all simple & useful tricks ...

Excel Compare Two Cells Text (9 Examples)

Oct 17, 2021 Excel Formulas

When we do compare two cells manually, it is not an issue. But it's next too difficult to locate the variations between hundreds and thousands of ...

If Cell Contain Word Then Assign Value in Excel (4 Formulas)

Oct 18, 2021 Excel Formulas

If you want to assign value to a cell based on a certain word in another cell then you'll need to build a formula because Excel doesn't provide a ...

How to Return Value If Cells Contain Certain Text from a List

Oct 18, 2021 Excel Formulas

If you have a list of text and want to search cells and return values based on the list, you'll need to build a formula because Excel doesn't provide ...

How to Remove Commas in Excel (From Text & Numbers)

Sep 8, 2021 Advanced Excel

In this article, I will show you how to remove commas from the names (placed in the middle/in-between/last) and the numbers in Excel. Download Excel ...