distinct

all, I need help I have 3 columns of data store id, store name and item no if I create a Pivot by store name and count of item no I get 250 store names and counts this works the problem is I am trying to perform a distinct count of SKUs across 5 stores I can do this in a pivot using...

Hi All, Is there a formula to find distinct count in a column without using COUNIF function. Currently I'm using the below formula, but it takes more time to complete 9000 rows of data i have. Can someone assist me on this pls. IFERROR(1/COUNTIFS(A:A,A2),"")

I want to select a single distinct example based on one field in a table. Something like: Select table.* From (Select distinct table.[country] from table) Where( . . . .) Is this possible in access sql?

Hello. I have sheets that have some numbers in C column. Then in J column there are some values that are in other sheet, the value depends from number in C column. Some are still have div/0. And i have several sheets that look like that. Now i need to get number of unique distinct values that...

How does distinct count work in pivot table? If I as summing distinct count of a customer and I showing three years of data for example If customer A bought stuff in all three years will he show three times or will he show in first occurence in data or will he show in first year of data...

HI, I am looking for to get a distinct count formula in a given column. For example, I have a column which contains ID's (both text and number - String), I would like to get unique count...if one ID repeated twice then I should get only once in the formula. Thank you,

I run some analysis that's fairly heavy. And one part involves getting unique instances of a customer where distinct data field would help. However Data Model seems to be really CPU time consuming. Since I know there are never really more than about 50 unique instance per customer per daily...

as the title states im trying it count distinct values from a column in a table from another workbook if the values are between a certain date range(cell a1 & cell a2). my current formula for the most part is =SUM(--(FREQUENCY('FY18-FY19 PPD.xlsx'!$B$2:$B$51003,'FY18-FY19...

Hello all :) I have a database in excel containing total hours worked by date. On the odd occasion the user will enter there hours worked more than once, if they submit their user form multiple times through out the day. I am trying to build a report that summarises the total number of hours...

So I have just one table that I added to the data model, to give me some of the flexibility of dax and afford me some practice time. I have a measure that is a distinct count on my "sites" column, to count unique store numbers in my data set. I would like the measure to ignore the filter...

Hi, This formula works fine to count distinct values in a range: =SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13)) But it does not works when there's blank cells in the range. There's a solution for this? Thanks

Hi All, I desperatly need help with powerbi. I am new to powerbi and I have 1 table with unqiue ids called headcount data and another table called survey data which has multiple ids. I have a relationship 1 to many from the headcount tble to the survey tble. I then have 3 filters:-...

I want to count distinct stock numbers J4:J1226 I'm using formula =SUMPRODUCT(1/COUNTIF(J4:J1226,J4:J1226)) and it works pleasantly. Now I want to add one more problem. When I filter out perhaps stock numbers worked by a particular person I want it to return a count distinct subtotal. I can...

Hey guys first post, good morning (well here anyway) to you all. I have looked for a solution to this and am hitting a bit of a blank, I am sure it must be answered somewhere Excel 2016. I want to add distinct count to a pivot table. in its simplest form, its sales rep, order counts, and...

Hello, I have a need in a pivot summarize one column by min and max date and another column by distinct count. In a default pivot the min and max date work fine but I cant get distinct count. So when I create the pivot in data model mode the distinct count works fine but now I can summarize...

Hey Everyone, I would really appreciate if someone can find me solution for this problem. I am using a Pivot table and need to use it as making interconnected graphs and it's just easier. However as when I want a count of something it counts all the rows in that column with the data but not...

I have a set of data that is salespeople (column A), and how much they sold (column C) by client (Column B). I need to get the top 5 clients by sales for each salesperson; however, no duplicates across salespeople. So if John Wilkes had $10M to Fun Company as his #1 , and Jane Bridges had $8M to...

Hello! I am trying to do a countif that counts one column (column D) to see if it says "face up" but I only want to include those that are distinct in Column C. Is there a way to write this?

Greetings, I have a pivot table where one of the fields is distinct count but I can't find a way to sort my distinct count. Is it possible? Thanks in advance for any help.

Hi all, Hi have a table with three columns, one for names (column A) and the other two for dates (Column B and C). I need to count the distinct dates from column B and C based on criteria on column A. For example, if the criteria is Paul the result must be 4 (count of distinct dates for this...