Shakil Ahmed

About author

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

Latest Posts From Shakil Ahmed

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

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

Before we delve into the methods, let's introduce the dataset that serves as the basis for our examples. The dataset comprises several authors, some of their ...

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

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

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

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

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

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 Code” columns ...

Combine Multiple Cells into One Separated by Comma in Excel

The sample dataset has a listing of products. We'll combine the products from the two columns into the fourth column, separating the values by a comma. ...

How to Concatenate Two Columns in Excel – 2  Methods

This is the sample dataset.   To concatenate the First Name and Last Name and get the Full Name.   Method 1. Combine Names in ...

How to Autocomplete from List in Excel (4 Easy Ways)

In this article, we will describe various techniques to autocomplete cells or columns from a list in Excel. We used Excel 2019 here, but the techniques apply ...

How to Make Multiple Selection from Drop Down List in Excel

We'll use a simple dataset to create a multi-selection drop-down. Method 1 - Making Multiple Selections from an Excel Drop-Down List with Duplicate ...

How to Perform Automatic Date Change in Excel Using Formula (5 Useful Methods)

We have two simple examples. We need an automatically update the present date and we need to calculate the time remaining to the next Christmas. ...

How to Extract Data From Table Based on Multiple Criteria in Excel

We have a dataset of movies, their genres, leading actors, and years of release. We will provide the Genre and Actor name as criteria in a separate ...

How to Generate List Based on Criteria in Excel (5 Methods)

We have a dataset of several people from different locations along with their vehicles. Using this data, we will form a list based on criteria. ...

Browsing All Comments By: Shakil Ahmed
  1. Bob, PivotTable is one of the prime features of Excel, so regardless of the version (contemporary versions) you should get it inside the “Insert” tab of the ribbon. But if you don’t find that there you may need to customize your ribbon. Click on File > Options, then follow the image pivottable to ribbon

    And if counting unique is your main goal right now you might get that using the UNIQUE function (and COUNT family function for counting).

  2. Thanks for commenting Merle, glad to hear that it helped you.

Advanced Excel Exercises with Solutions PDF