EXACT Function Archives

10 Best Practices with VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

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 (5 Methods)

Sep 23, 2021 Excel Formulas

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)

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

Sep 22, 2021 Excel Functions

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)

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

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

Excel Compare Text in Two Columns (7 Fruitful Ways)

Oct 17, 2021 Excel Basics

Comparing text in two columns in Excel is a significant task in our daily life especially when you have to find something compared to the given text. ...

Excel Compare Two Lists and Return Differences (7 Ways)

Sep 20, 2021 Excel Formulas

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

Excel Compare Two Strings for Similarity (3 Easy Ways)

Sep 20, 2021 Excel Formulas

You may need to compare two strings to complete your task. In Excel, you can do that easily. Today we are going to show you how to compare two ...

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

Excel Count Number of Occurrences of Each Value in a Column

Sep 19, 2021 Excel Formulas

For performing different tasks in Excel you may need to count the occurrence number of each value. Agenda for this article is to show you how to ...

How to Count Cells with Specific Text in Excel (Both Case Sensitive and Insensitive)

Oct 13, 2021 Excel Formulas

While working in Excel, we often have to count cells with some specific text. Today I will show some easy ways to achieve that. Download File ...

Excel formula to compare two columns and return a value (5 examples)

Oct 17, 2021 Data Analysis with Excel 9

In this article, I will show you several techniques of using Excel formula to compare two columns for matches and return a value. Your necessity ...

Top 20 Excel Limitations that might Frustrate You!

Sep 9, 2021 Advanced Excel 2

Excel is obviously one of the most important products in the world. It is very helpful in managing, analyzing data. But there is also something that ...