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