unique count

Hi all, I have been struggling with this situation and am hoping someone can help. I have found solutions that almost get me there, but, nothing fully fits my situation. Here is some example data: <tbody> site org count org category site1 org1 cat1 site2 org2 org2 cat2 site3 org1...

Hello I'm trying to flag unique values in an extremely large dataset with about 498,000 rows however every formula combination i've used (sumproduct and countif functions) always lock up my excel sheet. Does anyone know if there is a simpler way that doesn't use a large amount of system...

Hi, I'm trying to figure out how to have a calculated column flag just the first time (by date) and last time a user logs in. The problem I'm running into is that a user can log in 2 or more times on that first day they log in. I don't really care which of those lines gets flagged with a "1"...

Thank you for taking the time to look at my question. I have a production query that returns several columns of production data; see the example below: <tbody> Scan Date Operation Type Product Code Machine # Workpost # Barcode Serial Number 09/19/2014 23:49 CA CARCJ80S2586 S2 F01...

Ok I will keep it simple with two rows. What I am trying to do is count unique duplicate values from one row into another row. <colgroup><col><col span="4"></colgroup><tbody> Date Draw1 Draw2 Draw3 Draw4 9/16/2014 6 9 7 9 9/15/2014 6 1 9 3 </tbody> I am trying to count the number of...

Hi, What I have 2 columns Column A Column B John India, China Jeffy US Justine US, India John China John India I would like to get the unique count of column A, for say India which...

Hello, I am trying to find a way to count the number of unique words in a range of cells when each cell contains numerous words. For example: <tbody> The dog and the cat are asleep. The cat is inside. The dog is outside. </tbody> I'm looking for a way to count the unique words...

Hello all, I have a perplexing problem that I cannot solve, and would like to know if anyone could help. My sample data: <tbody> A B C D E F G H I J K 1 Raw Data 2 WO # Op # Serial # Program # NC Info # of Kickout Kickout Types Comments Unique WO with NC Pending Unique Serials...

Hi All, I'm trying to figure out how to solve this Unique Count situation based on multiple criteria Scenario: we have agents from different departments who produce different sales on different plan rates Raw Data <tbody> Employee Plan Rate Payout pts 1 20 50 1 10 100 2 30 200 3 30...

Hi, I did a search before resorting to post this query but unfortunately the results from the search (sumproduct / frequency / countif) seemed to be confusing to me.. and therefore this post I have sample monthly data for sales in one sheet as below.. <tbody> Month Inv No. Apr-13 743...

Hi all, Like all, apologies if this may have been answered already... I have a column that contains unique values and I am able to count the total amount of unique entries that updates when an autofilter is used. The formula I have used is...

Hi, I want to calculate how much unique data within specified date (before than or between). Assuming the data <tbody> Items Sales Sold on Tie Joseph 13-Jun-2013 Tie Susan 1-May-2013 Shirt Joseph 29-Jun-2013 Shoe Susan 14-May-2013 </tbody> I need the data to calculate only the item...

Hi... Can anyone please help....for unique count in excel with this below parameters... I want to know If A has many times but out will come a has two uniqe code. output will come :- A has two unique code D & B then unique count comes 2, HOW....please help...thanks... <TBODY> SE Name Code A C...

This formula is to return the unique values in a range. The range in question is a list of email addresses. =SUMPRODUCT(1/COUNTIF($P$2:$P$70348,$P$2:$P$70348)) I have used this formula to count unique values before and have not had problems. It returns 0 when it should be closer to 50 or 60k...

Hi All! Let's say I have a customer dataset with lots of data on each individual customer's past acquisitions. Let's say I have a unique identifier for each customer, the month of purchase, store location, the item purchased and other data as well, I can "throw" to the Pivot Table (or filter by...

Sheet1 <TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 107px"><COL style="WIDTH: 84px"></COLGROUP><TBODY><TR...

Hello All, I have a pivot table set up and I need to show a count of the number of students there are within a certain course. The problem I have is that the same student is on multiple rows as they attend several training units within the course. So when I use the count option it is counting...

Hello! I'm trying to write a formula (to no avail) which will return the number of unique counties in a given region. This formula will be on another sheet, but I usually do not have trouble referencing another sheet in a formula. The sheet with my data is 'Master List' and the other is...

I have people's names in Cells A9 to A42 and I want to count the number of unique people in the list so I can multiply the number of unique people by 40 and give me the total # of hours I have available in a week given a 40 hour work week. I came up with the following formula which works great...

I want to count the number of unique text values that appear in the same column but over four separate worksheets.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> So far I have found the following formula which works for a single worksheet but...