+ Reply to Thread
Results 1 to 4 of 4

Get distinct values using pivot table

  1. #1
    Registered User
    Join Date
    12-23-2014
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    17

    Get distinct values using pivot table

    Hi,
    I have 2 columns in my excel sheet as shown below. Using pivot table I want to see the count of S as 1 or somehow get distinct count of S as 1. Can anyone help?
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687
    S 220151687

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Get distinct values using pivot table

    Don't know for sure if it also available in Excel 2010

    But for excel 2013 it is

    Use the column in which S is located as row.

    Use the column in which 220151687 is located as value. Choose for only unique numbers.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Get distinct values using pivot table

    And if my earlier solution is not working in Excel 2010 use a helpcolumn.


    c9=countif($B$9:$B9;$B9) and drag down.

    Select the criteria in column C as value and choose for min. (which is in this case 1)

  4. #4
    Registered User
    Join Date
    12-12-2012
    Location
    kakinada
    MS-Off Ver
    excel 2007
    Posts
    1

    Re: Get distinct values using pivot table

    e1=countif($B$9:$B9;$B9)

+ 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. Pivot Table with Distinct Values
    By Ziggy4e in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-21-2014, 11:11 PM
  2. How to count distinct values from table in pivot table
    By gopijadhav in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2014, 07:14 AM
  3. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  4. [SOLVED] count distinct in Pivot table
    By soe in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 10:06 AM
  5. [SOLVED] Count Distinct Values by Group Using Pivot Table (NM)
    By MCP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 06:06 PM

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