User Posts: Shakil Ahmed
0
How to Convert Percentage to Basis Points in Excel
0

In the financial world, you may encounter the term Basis Points. It’s the usual hearing percentage and basis point simultaneously. Today In this article, we ...

0
How to Calculate Overdue Days in Excel (4 Easy Ways)
0

Today I’m going to show you how to calculate overdue days in Excel. Calculating overdue is a staple for any form of resource management. For this session, ...

0
How to Subtract a Percentage in Excel (3 Quick Ways)
0

Certainly, calculating percentages is a common task in our day-to-day lives. In countless situations, you may need to subtract a percentage, and this is where ...

0
How to Calculate Year over Year Percentage Change in Excel
0

Need to calculate year over year percentage change for your company? You can do that easily with Microsoft Excel. In today’s session, we will show you how to ...

0
How to Calculate Discount Percentage with Formula in Excel
0

Microsoft Excel is a powerful tool for basic and complicated calculations. With the help of it, you can easily calculate the percentage value, like a discount ...

0
How Do You Calculate Percentage Increase or Decrease in Excel
0

Microsoft Excel is a great tool for basic and complicated calculations. In today’s article, I’m going to show you how to calculate the percentage increase or ...

0
Selecting Non Adjacent Cells in Excel (5 Simple Ways)
0

In Excel, you can select adjacent cells very easily. It is a straightforward one. But selecting non-adjacent cells (you may also refer to them as ...

0
How to Print Selected Cells in Excel (6 Effective Ways)
0

As the use of Excel increases on a daily basis, we may need to have a printed hardcopy of our Excel spreadsheet. Varying on your work, you may want to print ...

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