ISNUMBER Function Archives

VLOOKUP to Find Duplicates in Two Columns

Sep 23, 2021 Excel Formulas

You may need to compare two columns in Excel to find duplicates or unique. In this article, we are going to show you how to find duplicates from two ...

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. ...

Lookup Partial Text Match in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, there are several useful methods to lookup partial text matches and then extract data based on that specific match. In this ...

COUNTIF Cell That Contains a Specific Text in Excel (Case-Sensitive and Insensitive)

Oct 24, 2021 Excel Formulas

Today I will be showing how you can use COUNTIF to count cell that contains a specific text within it. I will show both case-insensitive and ...

COUNTIF Partial Match (Couple of Easy Approaches)

Sep 23, 2021 Excel Formulas

COUNTIF is one of the most frequently used functions in Excel. A lot of tasks can be done using this function, one of them is the partial match. ...

How to Use ISNUMBER Function in Excel (7 Examples)

Sep 22, 2021 Excel Functions

In Microsoft Excel, the ISNUMBER function is generally used to check whether a given argument contains a numerical value or not. In this article, ...

How to Use SEARCH Function in Excel (3 Examples)

Sep 22, 2021 Excel Formulas

Today I will be showing how you can use the SEARCH function of Excel to search for a particular text within a given string. SEARCH Function of ...

How to Use FILTER Function in Excel (9 Easy Examples)

Sep 21, 2021 Excel Formulas

Excel 365 provides us a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using this ...

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 TRUE Function in Excel (With 10 Examples)

Sep 21, 2021 Excel Formulas

The TRUE function has a special type of compatibility in returning results based on logical conditions. In this article, I’ll discuss the ins and ...

Sum Using OFFSET and MATCH in Excel (With Alternative Options)

Oct 10, 2021 Excel Formulas 2

Today I will be showing how you can determine any sum by using the OFFSET and the MATCH functions of Excel from any set of data. Before going to ...

How to Filter Multiple Rows in Excel (11 Suitable Approaches)

Sep 20, 2021 Excel Formulas

In our practical scenario with Microsoft Excel, we have to filter columns as well as rows from a large range of data for analysis. In this article, ...

Filter Multiple Criteria in Excel (4 Suitable Ways)

Oct 10, 2021 Excel Formulas 1

Today I will be showing how you can filter out some data matching multiple criteria using the FILTER function of Excel. Before going to the main ...

Excel Filter Data Based on Cell Value (6 Efficient Ways)

Sep 20, 2021 Excel Formulas

Sometimes data in a worksheet is too complicated or crammed that we face difficulties to find out desired data. Retrieve data from a dataset ...