count unique values

  1. J

    Counting Unique Values from a Set List Based on Another Cell's Conditions

    I need help figuring out a formula that will allow me to count the number of unique occurrences for a list of values that show up within specific categories. Basically, I have data like this: A B 1 Booking Type Room Number 2 Office Hours 123 3 Office Hours 125 4 Event 200...
  2. P

    Count Unique Values

    Dear members, I am working as a Logistic consultant and optimizing processes is a big part of my job. I often have this issue that I need to count the number of unique values where I have a lot of data in. For example: I have 80.000 SKU's and 5.2000.000 orderliness a year, I like to find per...
  3. J

    VBA UDF: Count Unique Values with Optional Multiple Criteria

    Hello, I'm coming here for help on a UDF to count unique values with (optional) multiple criteria. I've pieced together the following code but am having trouble getting it to work (it throws a #VALUE error each time). Is there a way to get this code to work? Function...
  4. P

    Count the volume of Unique Results based on a condition (using structured references)

    Hi, I have a list of Account User IDs (Column 1) and a list of email addresses(column 2) associated with that user. I need to count the number of unique email addresses per user and display this on each row (column 3). The data I have is stored in tables so I need the formula to allow for...
  5. C

    Count Unique Text Value with multiples criterias

    Hello. I need to count the number of donors who have contributed as of 09/30/2017 in the North America region Only. How can I do it? I am using the frequency and match formulas, but I don't know how to use it with multiple criteria, such as, dates and region. I have this data, Region/...
  6. W

    Code/formulat to count values based on different columns and not including duplicates

    Hello everyone. I could really use some help with this problem I'm having (Sorry if the image is scaled too large: check the image with the following link if you can't see to column M, or resize screen: http://i.imgur.com/rJYRCPL.png) What I would like to do is to be able to count unique...
  7. D

    Count Unique Values based on multiple criterias

    Hi Excel Experts, I found this awesome formula from below URL:- http://www.mrexcel.com/forum/excel-questions/478311-counting-unique-non-error-non-blank-values-range-cells.html The contributed formula counts how many unique values in rows and omits errors and blanks. However, this only...
  8. S

    Count unique values with criteria

    Hi everyone, I have a list of data, that goes like this: Day Month Department Worker Sales 1 1.2015 Department 3 A 5 2 1.2015 Department 4 B 8 3 1.2015 Department 7 D 12 4 1.2015 Department 7 A 33 5 1.2015 Department 3 V 19 6 1.2015 Department 1 G 81 7 1.2015 Department 2 H 14 8 1.2015...
  9. T

    Formula to Count Unique ID numbers per month

    I need to count how many unique ID numbers there are per month.I have figured out how to count the unique ID's for the first month (Jan) but after that I'm having trouble trying to get the count right for Feb and Mar. Formula I used in cell E2 is...
  10. J

    Count Unique Value combinations with Conditions

    Hello Mr. Excel! I have a fairly large data set that i'm working with and I am trying to determine the number of unique combinations given a certain criteria. I have 3 fields i'm trying to compare, Active ("Y" or "N"), Customer Name (there are many different names), Project (there are many...
  11. D

    CSE formula to count unique instances

    Hello, I'm using a formula that I was kindly given once on this forum. It has served me well - I have cut n paste it many times and it has always worked till now. It's an array formula (CSE). SUM(IF(FREQUENCY(IF('all regs'!$C$10:$C$74865>=summary!$C$7,IF('all...
  12. D

    sumproduct with unique values

    I'm using a formula, learned on this forum, to count only unique records within a sumproduct formula. =SUMPRODUCT(($B$18:$B$741>=C4)*($B$18:$B$741<=C5)*(1/COUNTIF($D$18:$D$741,$D$18:$D$741))) C4 and C5 are dates - I wish to include records within two date ranges. The data in column D are...
  13. C

    count unique values based on a value of "Yes" in another column

    Need help trying to count unique values based on a value of "Yes" in another column? In column E I have a list of cities, used the following formula to get a count of unique cities - SUM(IF(FREQUENCY(MATCH(E$8:E$172,E$8:E$172,0),MATCH(E$8:E$172,E$8:E$172,0))>0,1)) But now I also want to...
  14. C

    Count unique text values if meet condition in another column and matching conditional sums

    There are 3 data points I need to calculate. Number of unique customer names if criteria in another column is met, the average of subtotal by customer if that same subtotal is met and then an average per box. So, what I need to know for following sample data set would be: 1. What is the total...
  15. M

    Count of unique cells?

    is there a formula to count the unique cells in a column? or formula to assign a binary value to a cell if another cell in the same row is unique to every other cell in its' column? Please help
  16. G

    Multiple & Variable Dynamic Count

    Ok, I came up with the need of modifing something already solved here is the case. In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [...
  17. G

    Count Unique Values Based on Another Column

    Ok, I came up with the need of modifing something already solved here is the case. In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top