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.
Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious operations like counting text cells, counting unique, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Without a doubt, VBA Macros help to solve various problems and automate repetitive tasks in Microsoft Excel. Now, concatenating strings and integers is one ...
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 ...
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 ...
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 ...
Depending on the circumstances you may need to select multiple values within a drop-down list. In this tutorial, I am going to show you how to make multiple ...
Today we are going to show some automatic date change formulas in Excel, in other words, how to change dates automatically through formulas in Excel. In many ...
Extracting the data at the time of necessity is the prime factor of using any spreadsheet, and Excel is not an exception. You store data in tabular form in ...
In this article, we will discuss methods to generate a list based on criteria in Excel. This will allow users to get the list of data from a dataset according ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
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
And if counting unique is your main goal right now you might get that using the UNIQUE function (and COUNT family function for counting).
Thanks for commenting Merle, glad to hear that it helped you.