1. W

    Distinct values - Powerpivot

    I've been doing some work to identify some issues with the data in a couple of my database tables. I've got one table [tbl_customer] with a reference number (unique) and details of customers, and another [tbl_sales] with details of the products that they've purchased (many products and many...
  2. A

    Removing Duplicates with Timestamp

    Hello, I have a column of datestamps in a sheet and I need to separate the date from the time (=Int or =left both work). Then I copy the formula down. With the column highlighted, I go to Data and use the Remove Duplicates function. The result lists the distinct dates, but when I click OK, the...
  3. J

    Extract unique value from column using DAX

    I've come across what I thought should be a simple problem, but I can't quite figure it out. I have a table that's the result of an expression that could have a column like this in certain instances: Row Key Index <tbody> AH4000 1 AH4000 2 AP9999 3 </tbody> What I want is to keep only...
  4. A

    identify distinct names in filtered list

    hi all, i am trying to work out a way of counting unique/distinct names in a list. Unfiltered is straightforward. In each row: countif($a$2:$a2,$a2). I need to be able to have a formula that will also operate on the same data when it is filtered. I aim to be able to identify distinct names by...
  5. E

    Distinct Count

    So I have multiple month-end dates in a column. I have the below formula which counts the number of distinct dates and that works, but as I add more month-ends throughout the year I keep having to adjust the below formula. I tried doing =SUMPRODUCT(1/COUNTIF(B:B,B:B)) but that seems to break it...
  6. A

    count distinct values in range multiple criteria

    I am trying to count distinct vehicle numbers in a fleet schedule that have come in for Maintenance between certain dates. I have used the formula below to count the number of distinct vehicles: =SUMPRODUCT(IF((Order_Date<=$O$4)*(Order_Date>=$E$4), 1/COUNTIFS(Order_Date, "<="&O4, Order_Date...
  7. H

    Distinct Count based on given criteria

    Hello, I am looking some help in getting distinct count by criteria. For example if you refer the below table I brought the distrinct count by using formala {=Sum(1/Countif(A:A,A2))} however, in additon to this need another conditional criteria. If given % different for no then it should...
  8. T

    Index/Match Next Distinct Value

    Hello - I have two columns: Column A | Column B 6022 WF102 6022 WF102 6023 WF104 I am using index/match to fill Column B using look up values in Column A. My goal is to grab the next distinct value in Column B. There are multiple vendors with the same product code...
  9. T

    Multiple Routes on Single Map

    Good Afternoon, I know this isn't an Excel question, but I was hoping someone on this board could help. I need to create mutiple routes on a map and was wondering if anyone new of a free service to do this task. Basically ill have 41 distinct across the US and the software my company uses you...
  10. M

    Pivot Table average works correctly when row is expanded, not when row is collapsed

    I'm using a PowerPivot measure to determine average sale amount by customer for a particular type of product by dividing their total sales of that product by a distinct count of the item. When it's expanded, it works beautifully: When I collapse the row though, it throws off the average...
  11. L

    Count Distinct

    Hi-- I'm trying to count distinct text values in a range. I found this formula on another help site =SUM(IF(A2:A10<>"",1/COUNTIF(A2:A10, A2:A10), 0)) .... but it gives me a self-referencing error and returns 0 (My formula is placed in column B). Thanks in advance.
  12. N

    Count Distinct Unique values with nested IFs Formula

    I'm looking for a formula to count distinct values in column E (Order Numbers) if they are on a specific date in column M and if the orders are complete, or have zero left to build, meaning column R values are equal to zero. I've used...
  13. R

    Distinct Result from Multiple Countif

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

    Distinct Count Formula

    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),"")
  15. J

    Select distinct but return all fields

    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?
  16. D

    Counting for distinct values from several sheets

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

    distinct count in pivot table

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

    Distinct Count Formula

    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,
  19. C

    Should I use Data Model

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

    count distinct from another workbook if between date range

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...