IF Function

Find Duplicates in Two Columns in Excel (6 Suitable Approaches)

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 Find Second Largest Value with Criteria (3 Ways)

For different purposes, you may need to find the second largest value in Excel. Today we are going to show you how to find the second largest value ...

Excel Increment Month by 1 [6 Handy Ways]

In some cases, we have to find the date after incrementing 1 month. Do you know the easiest ways and functions to do that? In this article, I’ll ...

How to Find the Max Value and the Corresponding Cell in Excel (4 Quick Ways)

Today I will be showing how you can find the max value and the corresponding cell from a set of data in Microsoft Excel. Download Practice ...

Excel Compare Two Cells Text (9 Examples)

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

INDEX, MATCH and MAX with Multiple Criteria in Excel

In Microsoft Excel, the combination of INDEX, MATCH & MAX functions is one of the most comprehensive formulas which will let you extract maximum ...

How to Find Minimum value in Excel (Formula and Pivot Table)

For different circumstances, you may need to find the minimum value in Excel, you can do that easily. Today we are going to show you how to find the ...

How to Add a 1 in Front of Numbers in Excel [7 Special Tricks]

You may attach a special type of number like 1 before the local phone number of the US to make it an international identity. It is also mentionable ...

How to Create Automatic Rolling Months in Excel (3 Quick Ways)

Today I will show how you can create a series of automatic rolling months in Excel and then arrange your data according to the series created. ...

Sum Based on Column and Row Criteria in Excel (7 Handy Ways)

There is a wide range of suitable methods to sum up a range of cells based on column and row criteria in MS Excel. In this article, I’ll try to ...

How Do I Count Cells with Text in Excel (5 Methods)

You need to count how many cells contain text within your data set for many different operations. Today we will show you how to count cells with text ...

Excel 2 Decimal Places without Rounding (4 Efficient Ways)

Sometimes we may need to get values up to two decimal places. There are several ways to do that. In this article, I will show how to get two decimal ...

Excel Count Number of Occurrences of Each Value in a Column

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 Extract Unique Values Based on Criteria in Excel

Extracting unique values based on single or different criteria is very common in office & business. Microsoft Excel has also added a few useful ...

If Cell Contain Word Then Assign Value in Excel (4 Formulas)

If you want to assign value to a cell based on a certain word in another cell then you'll need to build a formula because Excel doesn't provide a ...

ExcelDemy
Logo