Excel Formulas

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

How to Pull Values from Another Worksheet in Excel (6 Easy Ways)

We have a table with movie information in the sheet called Details. We will pull values from this table to the other worksheets. Method 1 ...

How to Add Hyperlink to Another Sheet in Excel (2 Easy Ways)

We have a worksheet called Sheet1 with the names of some students and their marks. We will add hyperlinks to this sheet in another worksheet of the ...

How to Match Data in Excel from 2 Worksheets (6 Methods)

Method 1 - Compare and Match Data from 2 Worksheets by Viewing Side-by-Side in Different Workbooks There are two sample workbooks named Book 1 and ...

How to Find Value in Range in Excel (3 Quick Methods)

Let's use a table that contains several actors from different film industries with one of their popular movies. We'll find different values based on ...

How to Find Text in Cell in Excel: 2 Suitable Examples

Method 1 - Combine SEARCH, ISNUMBER, and IF Functions to Find Text in Cell Steps: Select cell C5. Write down the following formula in the ...

How to Find If Range of Cells Contains Specific Text in Excel

The column named Text contains the intended text and the column Specific Text contains the strings that will be checked on the left column. The ...

How to Check If Cell Contains Specific Text in Excel (8 Methods)

We have a table that contains student information and their grades. We will check if a cell contains specific text. Method 1 - Using the ...

How to Concatenate String and Integer with VBA (5 Easy Ways)

Let’s consider the Employee Information dataset shown in the B4:E10 cells which contains the “First Name”, “Last Name”, “Country Code” and “Area ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo