Excel Formulas

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

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 Sum Top n Values in Excel (3 Suitable Ways)

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 Compare Two Lists and Return Differences in Excel

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 Strings for Similarity in Excel: 6 Methods

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 Add 30 Days to a Date in Excel – 7 Quick Methods

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

Sum with INDEX-MATCH Functions under Multiple Criteria in Excel

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

How to Create a Top 10 List with Duplicates in Excel (5 Ways)

Below is a basic table listing the sites and their respective monthly visits. The second column has a couple of duplicate values. Method 1 ...

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

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 Apply SUMIFS with Multiple Criteria in Different Columns

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

In the following image, you see two columns having similar names. Column E shows which names are exactly the same and which are not. In this ...

Excel SUMPRODUCT Function Based on Date Range (7 Examples)

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

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

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 Use COUNTIF for Date Range in Excel (6 Suitable Approaches)

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

How to Use Excel MIN and MAX in the Same Formula (2 Examples)

Below is the practice workbook, which is the base of our examples. Basics of MIN - MAX 1. MIN Function The MIN function returns the ...

SUMIF with INDEX and MATCH Functions in Excel

Here's an overview of the dataset and an example of the function to extract data by summing based on criteria. Introduction to SUMIF, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo