count distinct

  1. L

    Distinct count based on 2 columns in a Pivot Table

    How do I get the distinct count based on 2 columns using a Pivot Table? I did it 2 years ago and can't find my formulas or previous work. Survey response data: Area Responder District School Type Elem Mid Northeast Andy Green School District Washington Elementary School Elem 1 0...
  2. Z

    Find the Distinct Count of most common day for products used by day of the week (1-7) distinct count

    I have bike share data that indicates the day of the week a bike was used in number format 1-7 (indicates days of the week). I want to figure out the most common days of the week a specific route was most popular i.e. for each specific route which (number or) day was most common. I believe what...
  3. R

    Count Distinct Values after Filter

    Hello, I can usually find what I need to write complex formulas, usually on this forum, but this one has had me stumped for quite some time. I have data contained in a Table (Table1) with named ranges and need to count distinct document numbers where it does or doesn't meet certain criteria...
  4. L

    Count Distinct across two columns

    Hi - this the last question I have on a project, and it's a tricky one (to me!) Description: I keeping a spreadsheet for monthly Reading Group that shows month/author(s)/title(s)/page count/author gender/etc. <colgroup><col><col span="2"><col><col span="2"><col><col></colgroup><tbody> Month...
  5. D

    Count Distinct and subtotal

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

    Newbie-countrows distinct by month and customer where sales >0

    I am new to power pivot, I am trying to create a measure to calculate distinct customers buying per month where the total sales for the month and grand total are greater than 0. eg. Customer A buys in July 1000 units count would be 1, in august a credit is raised for 1000 units august count =...
  7. P

    Pivot Table - Calculated Field - Counting Distinct Values For with If Condition Met - Excel 2013

    How can I create a calculated field in a pivot table that will count distinct values of Field1, given that Field2 meets a particular condition? My limitations: Needs to be in a pivot table Needs to be a calculated field The calculated field needs to be a unique count "formula", not simply a...
    • Propelissa
    • Thread
    • calculated field count distinct count unique if condition pivot
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top