### How to Find If A Range of Cells Contains Specific Text in Excel (4 Methods)

While handling a large database you may need to find a specific text from the database. Excel has some functions by which you can easily do that. ...

### Excel Search for Text in Range (11 Quick Methods)

In Microsoft Excel, there are numerous methods available to search for text in a range of cells or an array. You can search for a text value and ...

### How to Find If Cell Contains Specific Text in Excel

In Excel, circumstances may demand checking whether a cell contains a specific text or not. Today we are going to show you how to check if a cell ...

### VLOOKUP to Find Duplicates in Two Columns (2 Ways)

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

### How to Use IF Partial Match in Excel (4 Basic Operations)

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)

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)

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)

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 in Excel (2 or More Approaches)

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)

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)

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)

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)

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)

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

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