Latest Blog Posts - Page 384 of 412

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 Using a Formula in Excel – 2 Methods

Aug 15, 2024

This is the sample dataset. Method 1 - Combining the Excel INDEX-SMALL Formula to Filter Data The INDEX function returns the ...

How to Filter Data Using a Formula in Excel – 2 Methods

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 Compare Text in Two Columns in Excel

May 22, 2024

For illustration, we will use following sample dataset containing two lists of items. Method 1 - Comparing Text in Two Columns For Matches ...

How to Compare Text in Two Columns in Excel

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)

How to Compare Two Lists and Return Differences in Excel

Jun 21, 2024

We have 2 lists: A list of all employees and a list of invited guests. We'll compare the lists and see which employees were not invited. In the image ...

How to Compare Two Lists and Return Differences in Excel

How to Compare Two Strings for Similarity in Excel: 6 Methods

May 29, 2024

Method 1 - Using Highlight Cells Rules Feature Steps: Select all the cells from B5 to C10. Go to the Home tab and click on Conditional ...

How to Compare Two Strings for Similarity in Excel: 6 Methods

How to Add 30 Days to a Date in Excel – 7 Quick Methods

Aug 4, 2024

30 or any number of days can be added to a date, using different functions Method 1 - Using an Algebraic Formula to Add 30 Days to a ...

How to Add 30 Days to a Date in Excel – 7 Quick Methods

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