+ Reply to Thread
Results 1 to 2 of 2

Please help! How to tell which counts are the same in pivot table

  1. #1
    Registered User
    Join Date
    03-11-2015
    Location
    Boston, MA
    MS-Off Ver
    10
    Posts
    1

    Please help! How to tell which counts are the same in pivot table

    Hi all,
    This is my first time using this forum, so if there is a thread already dedicated to this issue, kindly direct me there.

    I created a pivot table to track company customers in column A and the products sold to the customer in column C-G. I use the "count" feature to identify which of the products in C-G were purchased by the customer and a grand total by number of products in in Column H. My question is, if two customers each purchase 5 products, is there a way to tell whether they were the same or not? I have attached an example. While the example is for a small number of customers, I need to extrapolate this across 4,000+ customers so and looking for a way to identify identical orders, not just the same "grand total" number of products sold. Thank you so much for the help.

    image004.jpg

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Please help! How to tell which counts are the same in pivot table

    this would be easier if you uploaded the actual workbook instead of just your image, but i think you can accomplish what you're looking for with a pretty simple helper formula... are there really only those 6 products? if there are a lot of products this would get tedious to manage, but something like this should work:

    in column I
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    then in column J
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    (untested)

    i could also see doing this with a macro, if you don't like the helper column.

    probably other ways as well, that's just the first thing popping into my head.
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

+ 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. Replies: 2
    Last Post: 05-08-2013, 04:56 PM
  2. [SOLVED] Need help with Pivot Table for t-shirt counts
    By radiorotary in forum Excel General
    Replies: 1
    Last Post: 06-22-2012, 11:38 AM
  3. Pivot table - SUM of COUNTS?
    By nick_danger in forum Excel General
    Replies: 1
    Last Post: 03-10-2008, 11:43 PM
  4. [SOLVED] Pivot Table - Average of counts
    By Dan in NY in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  5. Pivot Table - Average of counts
    By Dan in NY in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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