unique count

  1. B

    vba code to copy unique data, transpose it and get count of the unique data

    I have a schedule of games for a sports league in sheet1 with dates in column “A” and remaining schedule data in the other columns. I need to take the dates and find just the unique dates and count the unique dates and paste them into a different sheet. The dates need to be transposed into...
  2. W

    UDF CountUniqueIF

    Hi ALL!! I've been working on a VBA project on and off for a little while to make things easier at work. to tell you a bit about my work, I'm actually a lab analyst rather than a data analyst, so mostly I'm mucking in testing tap water rather than playing around with excel :laugh:; but each...
  3. P

    Unique record count with multiple criteria

    Hi This is me first time posting on this forum, so hoping someone can answer. I have data in the below sample format. I am trying to get a record count when the values in column 1(Week) and column2 (Name) match together. For example, User1 has three entries for 7/14/2018. So in column3, I...
  4. S

    Unique count based on different cells

    I need to get unique value of Suppliers based on the different columns Input: <tbody> Functions Suppliers Sites Due Date Operations Apple #N/A #N/A Operations Orange #N/A 4/13/2020 End User Services Watermelon #N/A #N/A Operations Pineapple #N/A #N/A Operations Kiwi Mulgrave...
  5. E

    Count Unique Customers Who Order Using Formula

    Hi All, I'm trying to work out how many unique customers bought a particular product. Example Below <tbody> Product Orders Unique Buyers of Order Bouncy Castle 56 ? (Formula Required) Trampoline 32 ? <tbody> (Formula Required </tbody> Inflatable Pool 77 ? <tbody> (Formula Required)...
  6. J

    How to count unique values with few criterias between two lists/ Count the number of duplicates with few criterias bwtween two lists

    For example, I have two list, each with three columns of criteria. From here I want to find the number of unique customer ID that bought orange on Wednesdays. List 1 <tbody> Customer ID (Column A) Items bought (Column B) Day (Column C) 1 Orange Wednesday 2 Apple Tuesday 5 Pear...
  7. A

    Pivot table: Distinct count in Excel 2013 and 2016

    In Excel 2013 and 2016 there is the option to select "Add this data to the Data Model" when creating a Pivot Table. This will allow for summarize values by "distinct count" (finally!) I did not check the box when I made my Pivot Tables. However, I need the "distinct count" function and I do not...
  8. F

    Calculated Field COUNTIF of unique value in Pivot Table

    Hello all, I need some help with a function that I am not able to get working. I am using a Pivot Table to organize a large amount of date that is compiling information from a number of different pipeline sections and giving me a total count of how many units I need / size. I need to...
  9. I

    Countif unique values

    I'm trying to create a formula that will count the unique values from one stationary criteria and other data that can change <tbody> Name Customer Employee 1 Customer 1 Employee 1 Customer 1 Employee 2 Customer 1 Employee 2 Customer 2 </tbody> Looking at the data above i want to be...
  10. F

    Frequency/Match formula help

    Hi There, I'm a relative novice at Excel and I'm having trouble working out a formula. I'm trying to count the unique numbers in ROW G (Sectors) if certain criteria are met in other cells. For example, IF (1_hypothesis = 9) AND (1_for/against = D OR 1_for/against = CF) AND (1_thick/thin =...
  11. B

    How to get unique count (frequency) for a values with two criteria

    <colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody> Count Repeat Emp # CSR TM Group Presence Schedule Note Year 1 Yes 3133930 Nancy Gab FR Yes Day N/A 2016 2 No 45490 Angela MArvin FR No Day N/A 2015...
  12. E

    Marking first instance of unique value in large range, on low powered machine

    Hello, I have a large range of (sales) data which includes multiple orders ("order number"-s). Each order can contain 1 or multiple "lines". Each line can (confusingly) contain more than one entry. The reason for this is that a Line might contain values for: Manufacturing, Delivery, Handling...
  13. Ombir

    VBA to find unique from multiple columns and count on multiple criteria. Anybody please

    Hi friends, I have a worksheet shown below. <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead> A B C D E F </thead><tbody> 1 Dt Sb1 Sb2 Sb3 Sb4 Sb5 2 Am ENC HIC POS ECO CPU 3 Am ENC HIC POS MAS MAT 4 Bw ENC HIC POS ECO CPU 5 Bw ENC HOS PHE CHE...
  14. D

    Urgent: Help Needed

    Hi I do not know if this has been answered before but I am working on a critical project and need help. I have customer data with channel (online etc ) in one column and the customer id in next column for two years. What I want is a formula to calculate unique customers in first year who...
  15. P

    formula to count unique values based on today's date

    Hi I'm column B, i have a list of values (made of letter & numbers). In column K I have the date column B e.g. <TBODY> 151_92861310053100</SPAN> 039_6B7453EFADA0B0FFF1986A56E61F20FC</SPAN> 151_92861310053100</SPAN> 151_92861310282700</SPAN> 151_92861310282700</SPAN>...
  16. P

    formula to count unique values based on today's date

    Hi I'm column B, i have a list of values (made of letter & numbers). In a column C I have date column B e.g. <TBODY> 151_92861310053100</SPAN> 039_6B7453EFADA0B0FFF1986A56E61F20FC</SPAN> 151_92861310053100</SPAN> 151_92861310282700</SPAN> 151_92861310282700</SPAN>...
  17. M

    Calculating Number of Unique Values in Column

    Hello, I am preparing a usage report for a school's Learning Management System. I have downloaded the raw data of each login into an Excel file. Each row down the worksheet represents one login. Each column across the page represents some identifying information about the user. These columns...
  18. T

    unique count with criteria in a table

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

    Flag Unique Values with Multiple Criteria in large Dataset

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

    New User - Unique flag

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

Some videos you may like

This Week's Hot Topics

Top