unique values in a range

Hi All, I have the following dataset and I want the final answer to be a number of unique counts of "Record#", based on criteria 1=Variable1,"AAAA" and criteria 2=Variable2,"123". The two criteria are set as lists in a separate worksheet, so when the user selects variable 1 and variable 2, the...

Hi! I have a large dataset consisting of column A and B. In column A there is an ID that represents a voyage. In column B I have names on the persons that were on the different voyages. I want to calculate how many unique persons that were on the different voyages. How do I do that? Below I...

I'm fairly new to this and with some internet help I've managed to almost get it right, however would need my VBA to paste values only. I've tried with Paste:=xlPasteValues without any luck. Anyone able to help me tweak this one a bit so it copies only values? Sub copytoHScode()...

There have been numerous posts about how to count the number of unique values existing in a specific column of a filtered table. Responses often point to array formulas that use a combination of the FREQUENCY, SUBTOTAL and MATCH functions, for example...

Using INDEX+MATCH+COUNTIF to return unique values; I can't figure out where to add an argument that filters the range to look unique values that have an associated ID. Example: Col A has values A,B,C,D,E,F & G Col B has values 1 through 20 A normal INDEX+MATCH+COUNTIF using Col B as my...

This question has been asked a lot but for some reason the formulas I find here are not working. I have a database and I'm looking to find the number of unique values based on the following: Column A) Unique Listing Name (Repetitive) Column B) Client Name (Owner of different listings in Column...

Hello, and thank you in advance for any assistance I may receive. I have used this forum for years (I cannot retrieve my original account) and am so grateful that excel experts spend thier own time to look and solve complete stranger problems. I am at hour 4 on this and I just cannot make it...

I have a large batch of data, below is just a short sampling of it, that I am trying to report on. If the same store, on the same date, had the same style I only want it to be counted 1 time when I pull the data into my pivot table. I've tried concatenating those 3 elements; Store Name, Show...

Good Morning I need to do a count of people in a school (A) based on their value in columnB. Duplicate people are OK. Duplicate people in a school is not OK. I would want only the count of Unique ID-Schools if their value in B is 1 Example A B...

Hi all, This is my first time posting here after having read a lot of threads, but i'm currently facing something i cannot seem to solve. My situation is as follows: In one worksheet (A) of my Excel file I have a list of entries divided over four columns (A,B,C,D) and 8000 rows. these are...

Hi I have data in columns like this below. A- sellers, B - shops, C- shop addresses <tbody> <tbody> A B C D E F G Ana AA a Ana AA <tbody> * </tbody> Ana BB d Tom AA c Hank CC e Ana AA a Tom CC f Hank FF g Hank AA b Ana AA a </tbody>...

Hi...I need help on how to accomplish this problem. The array formula SUM(IF(FREQUENCY(IF(D14:D26 >= 90,MATCH(C14:C26,C14:C26,0)),ROW(C14:C26)-ROW(C15)+1),1)) only works for 1 condition but for multiple conditions like if the Training Index is <=89.99 and >=80, it doesn't work. In my second...

Hello everyone! mrexcel has been my top resource when it comes to Excel-related questions. Great to be a member now. What follows is a tricky combination (for me, that is) of - starting from several rows named "A", "B", ... with blank cells, zeroes and values larger than zero in columns named...

Let's say I have three columns where column C can contain "multiple" values like "John, Pete" instead of just "John" or "Pete". See table below... Is it possible in some way to make the slicer for Column C just show the unique values "John", "Pete", "George", instead of the combined ones like...

I found this formula on another site to count unique values in a range, but I don't fully understand what it is doing. Can someone explain? =SUMPRODUCT((G3:G314<>"")/COUNTIF(G3:G314,G3:G314&""))