+ Reply to Thread
Results 1 to 4 of 4

Distinct Count Function for Mac!

  1. #1
    Registered User
    Join Date
    03-29-2019
    Location
    Madrid, Spain
    MS-Off Ver
    MS Office 365
    Posts
    3

    Distinct Count Function for Mac!

    Hi everyone,

    I was using the distinct count function in pivot tables so it doesn't count duplicates.
    To have it available, the flag "add this data to data model" must be marked when inserting the pivot table from the data source.
    This has always been very helpful to me.

    I am using Mac now, and i am aware that the data model is not available, so i can't use the distinct count feature.

    Is there any way around so i can have a pivot table not counting duplicates?

    Thanks in advance!

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Distinct Count Function for Mac!

    Have a read of this: https://www.contextures.com/pivottablecountunique.html
    Rory

  3. #3
    Registered User
    Join Date
    03-29-2019
    Location
    Madrid, Spain
    MS-Off Ver
    MS Office 365
    Posts
    3

    Re: Distinct Count Function for Mac!

    Thanks!
    I used the COUNTIF method with a little variation.
    Not the same as the distinct count option, but it finally solved my problem.

    Thanks for the help.

  4. #4
    Registered User
    Join Date
    03-29-2019
    Location
    Madrid, Spain
    MS-Off Ver
    MS Office 365
    Posts
    3

    Re: Distinct Count Function for Mac!

    Thanks for the help.

    And sorry about crossposting.

    Wont happen again.

    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  2. No distinct count function in pivot table
    By AS Mcclain in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-25-2015, 12:37 PM
  3. How to count distinct value
    By Ankit_Kumar in forum Excel General
    Replies: 1
    Last Post: 06-22-2015, 03:19 AM
  4. Distinct count using vba
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2012, 07:54 AM
  5. Count distinct?
    By Africa in forum Excel General
    Replies: 4
    Last Post: 12-09-2011, 08:34 AM
  6. Function including a distinct count
    By bkatzman in forum Excel General
    Replies: 5
    Last Post: 05-19-2010, 04:18 PM
  7. Count Distinct only
    By John Moore in forum Excel General
    Replies: 4
    Last Post: 11-25-2005, 07:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1