### How to Sort Rows in Excel (2 Simple Methods)

Sorting is one of the most common tasks in Excel, every now and then one may need to sort data. Most of our daily activities require column sorting, ...

### Find Matches or Duplicate Values in Excel (8 Ways)

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

### How to use AVERAGE function in Excel (5 Examples)

Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical ...

### How to Use LARGE Function in Excel (6 Easy Examples)

When we need to find a specific largest value, like the 2nd or the 3rd biggest number in any dataset. The Excel’s LARGE function returns numeric ...

### How to Use SUM Function in Excel (With 6 Easy Examples)

MS Excel provides a most useful function called SUM for summation purposes. Formula with this function automatically updates with the addition or ...

### How to Use VLOOKUP Function in Excel (2 Examples)

Today I will be showing how you can use the VLOOKUP function of Excel. VLOOKUP Function of Excel (Quick View) Download Practice ...

### How to Use ROWS Function in Excel (With 7 Easy Examples)

The ROWS function is a popular Excel built-in function that can be categorized under  Lookup or Reference Function. This function returns the number ...

### Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

In Microsoft Excel, using Advanced Filter with multiple criteria allows us to add different logics and functions to execute a wide range of ...

### Excel Sum Last 5 Values in Row (Formula + VBA Code)

We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row. In this article, I’ll discuss the ...

### Top 10 Values Based on Criteria in Excel (Both Single and Multiple Criteria)

Today I will be showing how you can filter out the top 10 values based on any criteria from any set of data in Microsoft Excel. How to Find ...

### 3 Easy Ways to Sum Top n Values in Excel

Today I will be showing how you can sum any top n values from a data set in Microsoft Excel. Download Practice Workbook 3 Easy Ways to Sum ...

### Excel Top 10 List with Duplicates

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

### How to Find Top 5 Values and Names in Excel (8 Useful Ways)

Microsoft Excel has provided numerous ways to determine the top 5 values or names or both from a huge range of data. In this article, you’ll get to ...

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

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