Excel Formulas

How to Sum a Column in Excel (10 Easy Methods)

Download Practice Workbook Calculating the Sum of a Column.xlsx Method 1 - Use Arithmetic Formula Steps: Go to cell C12 and insert ...

How to Use Multiple IF Statements with Text in Excel (6 Methods)

Below is a dataset with the examination records of some school students. Our objective is to find the overall result of each student based on their ...

How to Use Formula to Automatically Remove Duplicates in Excel

In the following dataset, we have the Student Name, Marks, and Grade columns. The names of some students have been repeated along with their marks ...

How to Remove Duplicates Using the VLOOKUP Function in Excel – 2 Methods

The sample dataset showcases book names in two columns: “Book List-1” and “Book List-2”. To find duplicates and remove them: Method 1 - ...

Excel Formula to Find Duplicates in One Column (8 Easy Ways)

Method 1 - Using the COUNTIF Function to Find Duplicates in One Column Along with the First Occurrence We have a list of names in column B. The ...

How to Highlight Duplicate Rows in Excel – 3 Quick Methods

Method 1. Highlighting Duplicate Rows in One Column with the Built-in Rule in Excel 1.1. Including First Occurrence This is the sample dataset. ...

How to Find Matching Values in Two Worksheets in Excel

Method 1 - Using the EXACT Function in Excel to Find Matching Values in Two Worksheets We have two different datasets in two worksheets. The dataset ...

How to Fill Down to Last Row with Data in Excel (4 Easy Ways)

Here we’ve got a data set with the Names and Joining Dates of some employees. We'll fill the Employee IDs up to the last row automatically. ...

How to Count Duplicates in a Column in Excel – 4 Easy Methods

This is the sample dataset. Method 1. Using the COUNTIF Function to Count Duplicates in a Column in Excel 1.1 Counting Duplicates ...

COUNTIFS Unique Values in Excel (4 Easy Ways)

We’re going to use a Customer Record of Mars Group. This sample dataset includes some Product Names and Contact Addresses of the Customers who bought ...

How to Count Duplicate Values Only Once in Excel (4 Methods)

Dataset Overview The dataset comprises several authors, some of their books, and the respective release years of the books. With this dataset, we'll ...

How to Count Unique Names in Excel (6 Simple Methods)

In this article, we will demonstrate some methods to count unique names in Excel. Excel doesn't have a built-in function to count unique values or ...

Transfer Data from One Excel Worksheet to Another Automatically

Consider the following dataset where we have various smartphones and their information listed. We'll copy this data to other sheets. ...

How to create a Hyperlink to Another Sheet Based on the Cell Value – 4 Methods

Method 1 - Create a Hyperlink Based on Cell Value in the Context Menu in Excel Create hyperlinks to click a month name an be redirected to the sales ...

How to Link a Table in Excel to Another Sheet – 2 Methods

There are 2 worksheets: Sheet1 and Sheet2. In Sheet1, you have students' marks in Physics. In Sheet2, students' marks in Chemistry . ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo