unique count

I have 10,000 assets listed across 140 sites, each asset have varying frequency. I would like to count the number of sites that each asset type exists on based on there frequency and task type In the example I've created all the information is in one TAB however in my spreadsheet the the...

Hello All! I'm trying to create a formula that counts the number of unique dates with two criteria. I've actually searched within this forum and found a similar question, however because it was case-specific and the conditions differ to mine, the same cannot be applied to mine. The one with 2...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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