This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 77%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Dear Microsoft,
I would like to request support for Distinct Count in PivotTables for Excel for Mac.
Currently, Excel for Mac supports standard PivotTables but does not support Distinct Count because it relies on the Data Model/Power Pivot feature. This creates a significant limitation for Mac users who work with PivotTables and need to analyze unique values.
Distinct Count is a common requirement for reporting and data analysis, and having this feature available on macOS would improve compatibility with workbooks created in Excel for Windows and provide a more consistent experience across platforms.
Please consider adding Data Model support, or at least enabling Distinct Count in PivotTables, in a future release of Excel for Mac.
Thank you for your consideration.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 18%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Hello, I’m Virginia a fellow Windows user.
As we’re a user to user forum Microsoft will not see your comments/suggestions/feedback. I would recommend sending Microsoft your suggestion via the feedback app - Windows key + F key or via the web: