+ Reply to Thread
Results 1 to 4 of 4

Unique, without duplicates, and able to be counted in a pivot table...or another solution

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    Missouri, United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Exclamation Unique, without duplicates, and able to be counted in a pivot table...or another solution

    I have a large batch of data, below is just a short sampling of it, that I am trying to report on. If the same store, on the same date, had the same style I only want it to be counted 1 time when I pull the data into my pivot table. I've tried concatenating those 3 elements; Store Name, Show Date, & Style, thinking I could do something with that but everything I find wants to count them in the formula, but those are the 3 critical criteria to tell me how many times the style was shown. I'm thinking I just need them to have some numeric indicator so when I pivot the date and report based on style I can accurately show that even though the same style was in the same store on the same date it was only 1 "showing".

    I'll also throw out it is absolute that all the data elements I need to consider are not together but separated by various other data elements.

    * Note, the dates are in DD-MM-YY format...how my company does it.

    I really am stumped. Any help you can offer would be grand.

    HIDE FROM PDF RPRT Store Name Region Rep Name Show Date Style #
    BVB XZY Store BVB Ann 15-10-16 ABT2245
    UWBB Anything goes store South TAYLOR 22-10-16 ABT2245
    BVB XZY Store BVB Ann 15-10-16 ABT2245
    UWBB You're the bomb South TAYLOR 22-10-16 ABT2245
    UWDS Anything goes store Midwest Madison/Morgan 29-10-16 ABT2245
    UWDS Anything goes store Midwest Madison/Morgan 29-10-16 ABT2245
    BVB XZY Store BVB Ann 15-10-16 ABT2245
    UWBB You're the bomb South TAYLOR 22-10-16 ABT2245
    UWDS Anything goes store Midwest Madison/Morgan 29-10-16 ABT2245

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Unique, without duplicates, and able to be counted in a pivot table...or another solut

    I concatenated all the columns then used this formula to identify the unique values.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    12-30-2013
    Location
    Missouri, United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Unique, without duplicates, and able to be counted in a pivot table...or another solut

    I'm kicking myself because I was way overthinking this but thank you, thank you, thank you! You just saved me a ton of headache trying to figure this out.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Unique, without duplicates, and able to be counted in a pivot table...or another solut

    Thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Dynamic chart of counted data extracted from pivot table
    By ffbulle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-19-2016, 04:25 PM
  2. [SOLVED] Pivot Table fields based on two counted fields
    By tejas.itraj in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-17-2014, 10:53 AM
  3. pivot table display/formatting hide fields not being counted
    By oamrt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2012, 10:22 AM
  4. Replies: 5
    Last Post: 06-08-2012, 03:24 PM
  5. Replies: 1
    Last Post: 01-10-2012, 03:33 PM
  6. Replies: 2
    Last Post: 05-19-2010, 05:14 AM
  7. [SOLVED] Calculated Field in Pivot Table Based on Two Counted Fields
    By cmlits in forum Excel General
    Replies: 1
    Last Post: 03-30-2006, 12:50 AM

Tags for this Thread

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