+ Reply to Thread
Results 1 to 6 of 6

Producing a table of unique values.

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    Surrey, UK
    MS-Off Ver
    Excel 2007
    Posts
    9

    Producing a table of unique values.

    Hi guys - I've tried to play around with this with little success on a pivot table. I realise this is probably kindergarten level Excel and I'll feel pretty daft when shown.

    I've got a list of customers on one side, and a list of values on another. What's the simplest way I can display this so that it counts the number of different values used?

    Example:

    Customer Value
    ANDERSON AAAA
    ANDERSON AAAA
    ANDERSON AAAA
    ANDERSON AAAA
    BENNETT EEEEE
    COLLINS AAAA
    DENNIS AAAA
    DENNIS BBBB
    DENNIS CCCC
    DENNIS CCCC

    To create
    ANDERSON 1
    BENNETT 1
    COLLINS 1
    DENNIS 3

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Producing a table of unique values.

    Select data -> Insert -> Pivot table

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Producing a table of unique values.

    The simplest thing is to add a field at source...

    If the data is sorted by Customer and Value as implied in your data set then you would add a third column and use:

    Please Login or Register  to view this content.
    use this field as the DATA field in your PT set to SUM.
    Last edited by DonkeyOte; 01-17-2010 at 10:44 AM. Reason: typo in narrative

  4. #4
    Registered User
    Join Date
    03-05-2009
    Location
    Surrey, UK
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Producing a table of unique values.

    Excellent DonkeyOte! Thank you very much.
    Last edited by Kleinstein; 01-17-2010 at 10:48 AM.

  5. #5
    Registered User
    Join Date
    08-14-2014
    Location
    Manila
    MS-Off Ver
    10
    Posts
    2

    Re: Producing a table of unique values.

    Testing this reply
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-14-2014
    Location
    Manila
    MS-Off Ver
    10
    Posts
    2

    Re: Producing a table of unique values.

    Testing this reply.lightshot
    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)

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