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.
Excel provides several information functions to provide you with the necessary information and help you perform your desired tasks easily and swiftly. Today we ...
Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text function ...
The SUBSTITUTE function is one of the text functions available in Excel that replaces the existing text with new text in a string. If you want to replace your ...
Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text function ...
In this article, we will learn how we can use the MAX function in Excel. We will also discuss various applications of the MAX function in different scenarios. ...
Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical function- ...
Excel provides several math functions to help you perform mathematical tasks easily and swiftly. Today we are going to show you how to use a function in Excel ...
There are several lookup functions in Excel to perform various lookup and searching operations easily and swiftly. Today we are going to show you how to use a ...
Whenever you work on an Excel worksheet, you may want to find a relationship between two or more cells. Suppose you want to match criteria with other cells. In ...
In this tutorial, I am going to show you 4 practical examples of how to use the IFERROR function in Excel. You can use these methods even in large datasets to ...
Fortunately, there are a number of functions in Excel to perform various logical operations easily and swiftly. Today we are going to show you how to use the ...
There are a number of functions in Excel to make operations simpler, easier, and speedy. Today we are going to show you how to use the WORKDAY function in ...
Circumstances may demand different types of filter operations; advanced, dynamic, and so on. Our agenda for today is to show you how to use the dynamic ...
How often do you need to sort in Excel? The generic answer is, “Every now and then”. Sorting is one of the most common tasks while dealing with data. To help ...
To filter data in Excel is quite usual, often you need to filter data to find the sets of data you require to operate a particular operation. Today we are ...
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.