0

## How to Insert Date in Excel (7 Simple Methods)

There are several purposes for inserting dates in Excel; tracking any information or for any date-time calculation you need to insert dates. Today we are going ...

0

## How to Make Multiple Selection from Drop Down List in Excel (3 Ways)

Depending on the circumstances you may need to select multiple values within a drop-down list. In this tutorial, we are going to show you how to make multiple ...

0

## How to Change Dates Automatically Using Formula in Excel

For easing your task you may demand automatic update of date, time sequence number, etc. Excel provides you with a feature for that. Today we are going to show ...

0

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

Extracting the data on the time of necessity is the prime factor of using any spreadsheet, Excel is not an exception. You store data in tabular form in Excel ...

0

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

In Excel, sometimes you may need to generate a list based on criteria. Today we are going to show you how to generate a list based on criteria. For this ...

0

## How to Auto Populate Cells in Excel Based on Another Cell

How good would it be if cells get filled automatically? Most of the time we will love that. Today we are going to show you how to auto-populate cells in excel ...

0

## How to use IF Statement to Create a Drop-Down List in Excel

It’s quite often that you need to create a conditional drop-down list. The IF function is a useful one while dealing with any “conditional” operation. In this ...

0

## How to Use VALUE Function in Excel (5 Ideal Examples)

Excel provides several text functions to perform your desired text-related tasks easily and swiftly. One of them is a text function called: VALUE. Today we are ...

0

## How to Use Partial VLOOKUP in Excel(3 or More Ways)

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate partial ...

0

## How to Edit Drop-Down List in Excel (4 Basic Approaches)

In Excel, a drop-down list is a helpful feature to fill the right data in a field (cell or column) swiftly. Once you build the drop-down list you will feel the ...

0

## Use Excel VBA VLOOKUP to Find Values in Another Worksheet

Circumstances may arise when you need to use certain VBA codes that execute the operation from different worksheets, like you may need to use VBA VLOOKUP in ...

0

## How to Use VLOOKUP to Find Duplicates in Two Columns

In this tutorial, I am going to show you 8 quick tricks to use VLOOKUP to find duplicates in two columns. You can quickly use these methods even in large ...

0

## How to Use SUMPRODUCT with Multiple Criteria in Excel

In order to work with Microsoft Excel, we face different critical situations regarding different criteria. Circumstances may demand you to work with multiple ...

0

## How to Find Partial Match in Two Columns in Excel (4 Methods)

Depending on the circumstances you may need to compare a couple of columns. The comparison can be done in many forms, one of them being partial matching. Today ...

0

## How to Use IF Function to Find Partial Match in Excel (6 Ways)

IF function is one of the most common functions in Excel. Depending on circumstances different logical operations can be performed through this function. We ...

##### 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

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.