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 Unique Values Using Excel Pivot Table (3 Ways)

For this article, we'll use the List of Movies dataset ranging from B4 to D24 and containing the name of the Movie, Actor, and Release Year. The goal ...

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 Combine Text and Hyperlink in Excel Cell (4 Simple Ways)

Before jumping into the methods, let’s learn about the dataset for this article. It contains some texts for web pages or documents, which will be ...

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 Create Dynamic Hyperlink in Excel (3 Quick Ways)

The image below is the dataset example. Note that this is a basic dataset to keep things simple. In a practical scenario, you may encounter a ...

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 Edit Links in Excel (3 Methods)

The following sample dataset shows the Sales by Chris for the last five years. Method 1 - Update Values to Edit Links in Excel Steps: ...

How to Hyperlink to Cell in Excel (4 Simple Methods)

  We have included some famous Athlete names in the Athlete Profile. We will hyperlink to a cell with this dataset. Method 1 - ...

How to Remove External Links in Excel (8 Easy Methods)

  Method 1 - Using Edit Links Feature to Remove External Links from Cells Steps: Go to the Data tab. From the Queries & ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo