EXACT Function Archives

Excel MATCH Function Match Type (Greater/Less Than & Exact Match)

May 9, 2023

The MATCH function in Excel is a very useful function to find out exact or approximate data matches in Excel. However, you may have trouble choosing ...

Excel MATCH Function Match Type (Greater/Less Than & Exact Match)

How to Use IF-THEN Statements with Text in Excel (7 Examples)

Jan 31, 2023

Sometimes you may need to use some combination of functions in Excel for searching a particular text or returning the answer as text. So, if you are ...

How to Use IF-THEN Statements with Text in Excel (7 Examples)

Intersection of Two Columns in Excel (7 Easy Methods)

Feb 28, 2023

While working in Microsoft Excel sometimes we need to find intersection of two columns. But sometimes it becomes difficult if you are not aware of ...

Intersection of Two Columns in Excel (7 Easy Methods)

How to Use DMIN Function in Excel (4 Suitable Examples)

Jan 4, 2023

In many situations, we need to use the DMIN function to find the minimum value in a range of cells based on criteria. In the following article, we ...

How to Use DMIN Function in Excel (4 Suitable Examples)

How to Count Specific Names in Excel (3 Useful Methods)

Nov 23, 2022

While investigating large datasets in Excel, you might be required to count the number of cells containing a specific name. This article provides 3 ...

How to Count Specific Names in Excel (3 Useful Methods)

How to Use INDEX MATCH Formula in Excel (9 Examples)

Feb 16, 2023 2

Now and then, we have to search for specific information in our large Excel worksheet. But, it’s tiresome to search for it manually. A formula ...

How to Use INDEX MATCH Formula in Excel (9 Examples)

How to Find Duplicates without Deleting in Excel (7 Methods)

Feb 19, 2023

While dealing with a huge amount of data, we often encounter duplicate entry problems in Excel. The most used methods to find duplicates in Excel are ...

How to Find Duplicates without Deleting in Excel (7 Methods)

How to Extract Unique Items from a List in Excel (10 Methods)

Apr 30, 2023

If you want to Extract Unique Items from a List in Excel, this article will be very helpful for you. Here, we will walk you through 10 easy methods ...

How to Extract Unique Items from a List in Excel (10 Methods)

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

Feb 7, 2023

While working in Microsoft Excel, often we need to compare two cells in excel. This is a basic operation we do in excel and luckily, excel has ...

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

Return YES If 2 Cells Match in Excel (10 Methods)

Feb 15, 2023

We can compare two cells in MS Excel in different ways. Excel offers many easy methods to compare two cells and return a certain value if the values ...

Return YES If 2 Cells Match in Excel (10 Methods)

How to Count Repeated Words in Excel (11 Methods)

Mar 21, 2023

In Microsoft Excel, we work with a large amount of data. In a large datasheet, usually, we see some repeated words. It is tiresome to find out those ...

How to Count Repeated Words in Excel (11 Methods)

How to Delete Multiple Rows in Excel Using Formula (5 Methods)

Feb 16, 2023

This article gives a brief description of how to delete multiple rows in Excel using formula. There are several different ways to eliminate rows by ...

How to Delete Multiple Rows in Excel Using Formula (5 Methods)

How to Count Duplicates Based on Multiple Criteria in Excel

May 25, 2022 2

In Excel, you may have duplicate data in the same columns. These data may be a part of a unique set when you consider all the data along a row. To be ...

How to Count Duplicates Based on Multiple Criteria in Excel

Excel INDEX MATCH Example (14 Examples + Alternative)

Apr 20, 2023

For advanced lookups in Excel, the INDEX MATCH formula can be used instead of VLOOKUP. A combination of INDEX and MATCH functions is required for ...

Excel INDEX MATCH Example (14 Examples + Alternative)

IF with AND in an Excel Formula (7 Examples)

May 15, 2023

In Microsoft Excel, combining multiple functions to get output is everyday work. We use various operators to extract a particular result from a ...