Share via

How can i use pivot distinct count values excel 365 on web ?

Anonymous
2020-04-10T05:30:38+00:00

How can i use pivot distinct count values excel 365 on web ?  I can use this feature on excel 2013 https://www.youtube.com/watch?v=sId8vpdp1qw but i can't find this feature on excel 365 via website. Please help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2020-04-10T07:34:39+00:00

    Hi Sinthanun,

    I understand you are working in Excel for web and you want to use Distinct Count option to summarize value in Pivot table.

    To use Distinct Count option, one should add the data to Data Model. We can insert PivotTables in Excel for the web spreadsheet but to create Power Pivot data models, we will need Excel desktop application.

    Reference: Excel for the web

    Distinct Count option is available of Excel 365 desktop application, but not in online version.

    There are certain differences when working in Excel for the web and desktop application, to know more about it, please see Differences between using a workbook in the browser and in Excel

    We appreciate your understanding.

    Regards,

    Neha

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest