count unique

1. Count unique values across multiple columns ignore blanks

From the following example data set I need to count the number of chemicals that appear at least once in the selected range, but not their duplicates, and ignore any blank cells. I know the answer for this set should be 21, but I can't figure out how to create a formula to give me that answer...
2. Count of Unique Rows Using Multiple Criteria Ignoring Blanks in Data

From the following example data set I would like to count the number of rows where "Company A" and the word "Completed" appear but not counting duplicate values in the first column and ignoring the blanks that might appear in the first column. It is ignoring the blanks I am having difficulties...
3. Function Count Unique Visible Cells

Hello, I am trying to count unique cells in a filtered list. The macro I have to count total unique cells seems to work perfectly. but i'm trying to change it in two ways.. First is to have it count the unique cells that are not filtered/visible (visibility is set my filters, not group &...
4. Counting unique shipments

I need a way to count the unique numbers in this column in a pivot table. Ideally I do not want sort the data in the column either. Is this possible? So I want to see in a pivot table the count of unique shipments is 5 (12,25,26,27,28). <tbody> Number 12 12 25 26 27 28 27 12...
5. Google Sheets Count Unique with Multiple Criteria

For this Google spreadsheet I would like to do the following: Count the Unique "Provider User IDs" (column C) that meet the following criteria: a) Column H = "Incomplete" OR "Provider Missed" b) Column K = 3/24/14 < Value <= 4/30/14 c) Column X = "School 1" I believe I know how to do this...
6. Pivot Table - Calculated Field - Counting Distinct Values For with If Condition Met - Excel 2013

How can I create a calculated field in a pivot table that will count distinct values of Field1, given that Field2 meets a particular condition? My limitations: Needs to be in a pivot table Needs to be a calculated field The calculated field needs to be a unique count "formula", not simply a...
7. Count Unique Criteria Based on Criteria in One Column

I searched the other forums on counting unique criteria, but I was unable to locate an answer that fit what I am trying to do. Here is my data: Column A B C Smith, Susie Operations Yes Brown, Charlie Accounting...
8. count unique records in a nested sumproduct formula

I've been pulling my hair out here. I can get the results via access and using autofilter so I know what number I need to arrive at. I have a table of database registrants that includes, amongst other things, a date the record was entered and a unique identifier, in this case email address...
9. Count unique individuals by day?

This is driving me up a wall. I'm calling people, and need to get a unique list of callers by day. Reports weekly (or monthly). I'm actually tracking this in Access, but producing reports in Excel, so Excel is where I need to count it (I think). 1 call per line. So if Monday I can Bob 3 times...
10. Count unique/distinct items in filtered column

I'm going to do my best to explain: I have several colums with various pieces of equipment, serials and years. I may filter on one column, then I want to count the number of unique pieces of equipment left...Ultimately I may filter differently. Example: A B C YEAR...
11. Count unique, non-hidden cells only

I have a column with names of products, some of which appear multiple times. As I apply filters in other columns to my data, I want to be able to count the number of unique, non-hidden names that remain with a formula. Is there any way to do this so that the number of unique non-hidden names...
12. Counting the number of unique text values in a list with condition

Hello all, I have a list as shown below. I want to be able to count the number of unique values in the 'Description' column, that are aligned to a particular axis value. For example, the function for axis B, value Z should return 2 as there are two items (pot & desk) which are unique...
13. Help Finding unique values from a database with a criteria

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Please help me count unique data from a table having 2 columns one with alphabets. as shown below.<o:p></o:p> <o:p></o:p> <TABLE class=MsoNormalTable style="WIDTH: 123pt; BORDER-COLLAPSE...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back