Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

User Posts: Shakil Ahmed
1
How to Count Unique Values Using Excel Pivot Table (3 Ways)
-2

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious operations like counting text cells, counting unique, ...

1
How to Count Duplicate Values Only Once in Excel (4 Easy Ways)
-2

In this article, I will show you the procedures of counting duplicate values only once in Excel. While working in Excel, we need to perform various count ...

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

In Excel operations, we need to retrieve data from time to time. Basically, the pulling values can be stored in the same worksheet or a different worksheet or ...

1
How to Create Dynamic Hyperlink in Excel (3 Quick Ways)
-2

Microsoft Excel allows you to deal with links. Cases can be like hyperlink to cell, find links, deal broken links, and many more. Today we are going to show ...

1
How to Hyperlink to Cell in Excel (4 Simple Methods)
-2

Hyperlink means to create a link between two or more data. It takes you to the detailed data whenever you click on the link. You can connect your data or cells ...

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

Circumstances may demand you to find value from a range. Finding, and retrieving are common operations in Excel. Today we will show you how to find value in a ...

0
How to Find a Character in String in Excel (9 Suitable Examples)
-1

In Excel, we can find a specific character within a string. Several built-in functions help us find the character. Today we are going to show you how to find a ...

0
How to Find and Replace Values Using Wildcards in Excel
-1

Today we are going to show you how to find and replace using wildcards. While dealing with data in Excel you may need to eradicate errors or modify your data ...

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

In Excel, circumstances may demand checking whether a cell contains a specific text or not. Today we are going to show you how to check if a cell contains ...

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

Without a doubt, VBA Macros help to solve various problems and automate repetitive tasks in Microsoft Excel. Now, concatenating strings and integers is one ...

0
Combine Multiple Cells into One Separated by Comma in Excel
-1

In this tutorial, I am going to share with you 6 simple methods to combine multiple cells into one separated by a comma in Excel. You can easily apply these ...

0
How to Merge Rows in Excel (5 Easy Ways)
-1

In Excel, situations may arise when you need to merge cells (rows and columns). Today we are going to show you 5 easy methods to merge rows in Excel. ...

0
How to Concatenate Two Columns in Excel (2 Suitable Methods)
-1

While using Excel, circumstances may demand joining elements from two columns. To assist you then, we are going to show you today how to concatenate two ...

0
How to Number Rows in Excel (9 Simple Methods)
-1

In Excel, you may come across repetitive tasks often. To number rows is one of these tasks which can be a time-consuming one. There are several ways of ...

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

The article will show you how to autocomplete from list in Excel. Every time we do a monotonous task, we may wish we could have done things differently. Excel ...

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.

ExcelDemy
Logo