AGGREGATE Function Archives

Excel Partial Match Two Columns (4 Simple Approaches)

Nov 25, 2021 Excel Formulas

Depending on the circumstances you may need to compare a couple of columns. The comparison can be done in many forms, one of them is partial ...

VLOOKUP Partial Match Multiple Values (3 Approaches)

Nov 8, 2021 Excel Formulas 1

Circumstances may demand a partial match with multiple values. Our Agenda for today is to assist you in performing a partial match using VLOOKUP with ...

Minimum Value Based on Multiple Criteria in Excel (7 Ways)

Sep 23, 2021 Excel Formulas

MS Excel provides a simple function called MIN which returns a minimum value from any range. But there might be a case where we need to find or ...

How to Arrange Numbers in Ascending Order in Excel using Formula

Nov 2, 2021 Excel Formulas

Depending on different circumstances you may need to arrange numbers, among other things, in a certain order. You can quite easily do the task using ...

Excel Top 10 List with Duplicates

Oct 26, 2021 Excel Formulas

For different purposes, you may need to find the top n number of values in Excel, n can be 5 or 10 and many more. Today we are going to show you how ...

Excel Find Lowest Value with Criteria [9 Effective Ways]

Oct 24, 2021 Excel Functions

Finding the lowest value may be an essential task in some cases. Have you tried this basic calculation? In this article, I’ll show nine effective ...

Index Match Sum Multiple Rows

Nov 3, 2021 Excel Formulas

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

Sep 20, 2021 Excel Formulas

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

INDEX, MATCH and MAX with Multiple Criteria in Excel

Nov 3, 2021 Excel Formulas

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

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

Nov 3, 2021 Excel Formulas

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

Excel Count Visible Rows (Formula and VBA Code)

Sep 19, 2021 Excel Formulas

To satisfy the demand of different circumstances you may need to count only the visible rows in Excel. Today we will show you how to count visible ...