count unique

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

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

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 &...

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

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

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

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

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

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

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

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

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

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