Excel Functions

How to Find Second Largest Value with Criteria In Excel

Method 1 - Using LARGE Function The LARGE function can return the largest number from a list of numbers after we sorted it in descending order. Let ...

How to Increment Month by 1 in Excel (8 Handy Ways)

We have a dataset of dates in the cell range B5:B16. We will calculate the 1-month increment of the given dates. Method 1 - Use the ...

How to Find the Max Value and Corresponding Cell in Excel (5 Methods)

Dataset Overview Finding the maximum value and its corresponding cell involves identifying the highest value(s) within a dataset and determining the ...

How to Compare Text Between Two Cells in Excel (10 Methods)

Method 1 - Use "Equal to" Operator to Compare Text Two Cells in Excel (Case Insensitive) For this method let’s consider a dataset of fruits. In the ...

INDEX, MATCH and MAX with Multiple Criteria in Excel

Combining INDEX, MATCH, and MAX functions is one of the most comprehensive formulas which will let you extract maximum or largest values under ...

How to Find the Minimum Value in Excel – 6 Easy Methods

This is the sample datset. Method 1 - Using the MIN Function to Find the Minimum Value in Excel The syntax for the MIN function is ...

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

In this article, we'll demonstrate how to use the INDEX & MATCH functions to find the minimum or smallest value in Excel, using the Microsoft 365 ...

How to use SUMPRODUCT Function with Multiple Columns in Excel: 4 Suitable Methods

Method 1 - Using SUMPRODUCT with Multiple Columns Under AND Logic Criteria Steps: Select cell G15, and type the following formula: ...

How to Calculate YTD (Year to Date) in Excel [9 Simple Ways]

The sample workbook will provide a few different scenarios for when you need to calculate YTD in Excel, such as YTD price, profit, or growth rate. ...

How to Apply SUMIF with Multiple Ranges in Excel

In the sample dataset, we want to get the total price of Apples by adding the price in the January, February, March and Discount columns using the ...

How to Create Automatic Rolling Months in Excel – 3 Methods

  Consider the date: 2-May-19. To automate the dates with rolling months: Method 1 - Create Automatic Rolling Months Using the Fill ...

How to Use the SUMPRODUCT with INDEX and MATCH Functions in Excel

Introduction to the Functions - SUMPRODUCT, INDEX and MATCH (with Examples) Before delving into how these three powerful functions work together, ...

Sum Values Based on Date in Excel (4 Ways)

Here's a sample dataset that will be used to explain the concept of sum values based on dates in Excel. It's a simple sales table with the date of ...

4 Easy Methods to Calculate the Year-to-Date Sum (Based on Month)

Method 1 - Calculating the Year-to-Date Sum Based on Monthly Input Example Model: STEPS: Enter the following formula into cell C16. ...

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

We will use a sample dataset where the sales of computers of different brands have been recorded over 6 months. Method 1 - Using the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo