+ Reply to Thread
Results 1 to 5 of 5

need to count unique value in pivot in Excel 2007

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    need to count unique value in pivot in Excel 2007

    i attahed herewith screen shot

    Capture.JPG


    in which pivot table showing 3 for 31/03/18 and 6 for 23/04/2018
    but cheque no is same so i want 2 for 31/03/2018 and 2 for 23/04/2018
    please guide how to do this
    Last edited by sharadmaxwell; 04-10-2018 at 05:31 AM. Reason: edit screshot

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: need to count unique value in pivot in Excel 2007

    Perhaps Drag Cheque once again into Row label.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: need to count unique value in pivot in Excel 2007

    There is no distinct count option in excel 2007. I always use a workaround with a formula in a help colomn

    Please Login or Register  to view this content.
    It will put a 1 value next to every first occurence of a cheque number and a "blank" value for every next time same checkno comes up
    Also in the pivot make sure you use sum and not count total of unique checkno.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    Re: need to count unique value in pivot in Excel 2007

    Thanku Sir
    and need one more help with your attahced file
    see the screen shot

    Capture.JPG

    i need 2 on 03 march and 1 on 6 march

  5. #5
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: need to count unique value in pivot in Excel 2007

    Ok, so you need a more complex match, I also realized after posting that each NAme (colomn A) could have the same CHQ Numbers at some point

    SO I now made a 3 point match for unique count.
    1. Cheq no
    2. Name
    3. Cheque / payment date

    See attachment for new formula
    Attached Files Attached Files

+ 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. [SOLVED] Pivot Count Unique values - Excel 2010
    By ats1312 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-27-2017, 10:32 AM
  2. [SOLVED] Count unique values in pivot table - excel 2010
    By Tino XXL in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2014, 04:45 AM
  3. [SOLVED] Count Unique Items, Based on Multiple Variables - Excel 2007
    By Joe Frenger in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2014, 03:13 AM
  4. Replies: 0
    Last Post: 03-22-2012, 08:44 PM
  5. Replies: 2
    Last Post: 02-11-2012, 09:33 PM
  6. Excel 2007 : Pivot Table unique values
    By penny.rhine in forum Excel General
    Replies: 12
    Last Post: 01-17-2011, 05:12 PM
  7. Excel 2007 - count unique records in Filtered Table
    By redbrad0 in forum Excel General
    Replies: 0
    Last Post: 05-26-2010, 08:20 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