Excel Formulas

How to Use COUNTIF for Date Range in Excel (6 Suitable Approaches)

In MS Excel, the COUNTIF function is used to count cells under different criteria. In this article, you’ll learn effectively how you can use this ...

Excel MIN and MAX in Same Formula

You may have used the MIN and the MAX function separately in Excel many times. But when it matters to use the functions within the same formula, you ...

SUMIF with INDEX and MATCH Functions in Excel

In Microsoft Excel, the SUMIF with INDEX-MATCH functions is widely used to extract the sum based on multiple criteria from different columns & ...

How to Compare Rows in Excel for Duplicates

Today I will be showing how you can compare rows in Excel for finding duplicates. Download Practice Workbook How to Compare Rows in Excel ...

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

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

ExcelDemy
Logo