Excel Functions Archives - Page 24 of 29

How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Jun 27, 2024

Excel FILTER Function: Overview We have the years, the host countries, the champion countries, and the runners-up countries of all the FIFA World ...

How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Dynamic Named Range Based on Cell Value in Excel

Jun 3, 2024

The basic idea of naming a range is the simple — we will use the Name Manager from the Formula tab. For each method, we are going to use the same ...

Dynamic Named Range Based on Cell Value in Excel

How to Sort Columns in Excel Without Mixing Data (6 Methods)

Jul 22, 2024

Dataset Overview Suppose you have a basic table containing the names of students and their respective scores in three courses. In this scenario, ...

How to Sort Columns in Excel Without Mixing Data (6 Methods)

How to Sort Multiple Columns in Excel (5 Quick Methods)

May 15, 2024

We will use the sample dataset below for illustration. Watch Video – Sort Multiple Columns in Excel Method 1 - Using ...

How to Sort Multiple Columns in Excel (5 Quick Methods)

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

Aug 4, 2024

Download the Practice Workbook Finding Sum of Last 5 Values.xlsm 5 Simple Methods to Sum Last 5 Values in a Row in Excel We have a ...

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

How to Get Top 10 Values Based on Criteria in Excel

Jun 1, 2024

We'll use a dataset with student Names and marks in Physics, Chemistry and History. Note that this article uses Excel 365. Some functionalities may ...

How to Get Top 10 Values Based on Criteria in Excel

Using the OFFSET Function to Create and Use a Dynamic Range in Excel – 3 Examples

Aug 13, 2024

This is an overview: The Excel OFFSET Function Objective: Return a reference to a range that is a given number of rows ...

Using the OFFSET Function to Create and Use a Dynamic Range in Excel – 3 Examples

How to Filter Data Based on Cell Value in Excel (4 Easy Methods)

Jun 14, 2024

The following GIF shows the filtered rows based on the device name from the drop-down selection, which we'll create. Method 1 - Apply ...

How to Filter Data Based on Cell Value in Excel (4 Easy Methods)

How to Sum Top n Values in Excel (3 Suitable Ways)

Jul 24, 2024

Download the Practice Workbook Sum Top n Values.xlsx 3 Methods to Sum Top N Values in Excel Let’s sum up the top 5 sales from January in ...

How to Sum Top n Values in Excel (3 Suitable Ways)

Sum with INDEX-MATCH Functions under Multiple Criteria in Excel

Jul 29, 2024

Dataset Overview The screenshot below provides an overview of the article, showcasing a dataset and an example of how you can evaluate sums in Excel ...

Sum with INDEX-MATCH Functions under Multiple Criteria in Excel

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

Jun 24, 2024

In Excel 2019 or earlier versions, when using array formulas, press Ctrl + Shift + Enter instead of the Enter key and drag down the Fill Handle icon. ...

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

How to Apply SUMIFS with Multiple Criteria in Different Columns

Jun 18, 2024

Method 1 - Apply the SUMIFS Function with Comparison Operators We are going to sum all the values greater than a given benchmark from a ...

How to Apply SUMIFS with Multiple Criteria in Different Columns

Excel SUMPRODUCT Function Based on Date Range (7 Examples)

Apr 30, 2024

An Introduction to the SUMPRODUCT Function This section is mainly for beginners. It'll explain the SUMPRODUCT function and the process of ...

Excel SUMPRODUCT Function Based on Date Range (7 Examples)

How to Return Multiple Values Based on a Single Criteria in Excel

Apr 23, 2024

In the example below we have the list of all the FIFA World Cups from 1930 to 2018. We have the Year in Column B, the Host Country in Column C, the ...

How to Return Multiple Values Based on a Single Criteria in Excel

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

Jun 28, 2024

Here's an overview of the sample dataset and an example of the COUNTIF function to count data based on multiple criteria. The function is counting ...