EXACT Function

### How to Match Names in Excel Where Spelling Differ (8 Methods)

Comparing data in excel rows is common while doing any data analysis task. In this article, I’ve explained eight methods to match names in Excel ...

### Count Specific Characters in a Column in Excel (4 Methods)

Corporate datasets are usually lengthy, and it becomes tedious to maintain and sort out data when necessary. MS Excel has some time-saving tools like ...

### How to Use Multiple IF Statements with Text in Excel (6 Quick Methods)

Many a time while working in Excel, we have to work with multiple IF statements to add different conditions or criteria. In this article, I’ll show ...

### Excel Formula to Find Duplicates in One Column

In Microsoft Excel, there are numerous methods available to find duplicates in a single column. We can insert a function or use a combined formula to ...

### How to Find Matching Values in Two Worksheets in Excel (4 Methods)

While working with a large dataset or multiple worksheets in Excel, there is a possibility that you are getting the same matching values in both of ...

### COUNTIFS Unique Values in Excel (3 Easy Ways)

While working in Excel, we often have to sort out the unique values from a set of data. Sometimes we have to count the number of equal values in a ...

### How to Count Duplicate Values Only Once in Excel (3 Ways)

In Excel, we need to perform various count operations, i.g. Count date occurrences, count text cells, count unique, counting duplicates, and many ...

### 10 Best Practices with VLOOKUP in Excel

In Microsoft Excel, the VLOOKUP function is generally used to extract data based on a lookup value in a column or a range of cells. In this article, ...

### How to Count Duplicates in Excel (6 Easy Methods)

While working with a large amount of data or compiling multiple worksheets into a bigger one, duplicate values, columns or rows may appear. Sometimes ...

### Find Matches or Duplicate Values in Excel (8 Ways)

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 Use UPPER Function in Excel (4 Examples)

In Microsoft Excel, the UPPER function is generally used to convert all the letters in a string of text to block ones. In this article, you’ll get to ...

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

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

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

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

### How to Compare Text in Two Columns in Excel

Comparing text in two columns in Excel is a significant task in our daily lives, especially when we have to find something that compares to the given ...

### How to Compare Two Lists and Return Differences in Excel

Sometimes we need to compare two lists in Excel for various purposes. In Excel, the list can be presented in two ways. It can be column-wise or ...