Latest Posts

How to Find Maximum Value in Excel with Condition (5 Ways)

In various calculations, we may need to calculate maximum values from any given dataset. Excel provides its built-in function which is the MAX ...

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

Index Match Sum Multiple Rows

You may need to calculate the sum of multiple rows that match any criteria. Today we will show you how to apply INDEX - MATCH to sum multiple rows. ...

Excel Find Second Largest Value with Criteria

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

SUMIFS Multiple Columns in Excel (5 Types of Application)

In certain circumstances, we have to calculate the sum value dealing with multiple columns. The SUMIFS function is a good choice in those cases. ...

VLOOKUP Max Value in Excel (With Limitations and Alternative Options)

Today I will be showing how you can extract the max (maximum) value from a database using the VLOOKUP function of Microsoft Excel. Download ...

INDEX-MATCH Formula to Find Minimum Value in Excel (4 Suitable Ways)

INDEX and MATCH functions are two of the most common functions in Excel chores to search for as well as store different data from a large array. In ...

SUMIF with Multiple Criteria (5 Easiest Examples)

For conditional sum in Excel, SUMIF is one of the most used functions provided by MS Excel. It is a combination of SUM and IF (SUM+IF), which means ...

COUNTIF Between Two Dates

For different purposes, you may need to find how many occurrences are there between two dates. You can fetch the count value easily once you have ...

SUMPRODUCT Function with Multiple Columns in Excel (4 Simple Ways)

SUMPRODUCT function is one of the most powerful array functions in Microsoft Excel that can pull out data from an array based on the criteria along ...

ExcelDemy
Logo