0

## How to Use COUNTIF Function for Partial Match in Excel

The COUNTIF function is one of the most frequently used functions in Excel. A lot of tasks can be done using this function, one of them is the partial match. ...

0

## How to Use VLOOKUP in Excel for Finding Multiple Values with Partial Match

Circumstances may demand a partial match with multiple values. Our agenda for today is to assist you in performing a partial match using VLOOKUP with multiple ...

0

## How to Use VLOOKUP Function to Compare Two Lists in Excel

Performing a comparison between a couple of lists is one of the familiar tasks in Excel. Today we will show how to compare two lists using the VLOOKUP function ...

0

## VLOOKUP with Two Lookup Values in Excel (2 Approaches)

Depending on circumstances you may need to use multiple lookup values with VLOOKUP. For easing your effort, today we are going to show you how to use VLOOKUP ...

0

## Combining SUMPRODUCT and VLOOKUP Functions in Excel

In Excel, you may need to use different sum family functions: SUM, SUMIF, SUMPRODUCT, and so on. Depending on the circumstances, it’s quite common to pair ...

0

## How to Use VLOOKUP Function with 2 Conditions in Excel

In Excel, you may need to search for values using different lookup functions like- the LOOKUP, VLOOKUP, and HLOOKUP Functions. Today I am going to show you how ...

0

## How to Write Greater Than or Equal To in Excel IF Function

In general, the IF function in Excel is a logical function where you may need to use various comparison operators: equal, not equal, greater than, less than, ...

0

## How to Sort Duplicates in Excel (2 Easy Methods)

Sorting is one of the most common tasks in the daily use of Excel. You need to perform various sorts; sort multiple columns, sort dates, sort data ...

0

## How to Sort Rows in Excel (3 Easy Ways)

Sorting is one of the most common tasks in Excel, every now and then one may need to sort data. Most of our daily activities require column sorting, but if you ...

0

## How To Search Multiple Items in Excel Filter (2 Ways)

One of the more common tasks in Excel is filtering data. Probably in every aspect of your Excel use you are using the filter, filtering can be done with single ...

0

## How to Sort Alphabetically and Keep Rows Together in Excel

Everyone appreciates decorated things. Even in terms of working with Microsoft Excel, we love to decorate our data. We can sort data alphabetically and keep ...

0

## How to Use VBA DIR Function in Excel (7 Practical Examples)

The DIR function in VBA mainly shows you the directory or the files from a given folder. It can also return the first file with this function. This function ...

0

## How to Use VBA UCASE Function in Excel (4 Examples)

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this article, we ...

0

## How to Use VBA SPLIT Function in Excel (5 Examples)

Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this article, we ...

0

## How to Use ISNA Function in Excel (3 Suitable Examples)

Excel provides several information functions to provide you with the necessary information and help you perform your desired tasks easily and swiftly. Today 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.