Results 1 to 5 of 5

Count of unique stores in a group

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    25

    Count of unique stores in a group

    I have data with three columns,

    Store #
    Group Name
    Item #

    Every store # is associated to a particular Group Name, however a store # will appear more than once due to different Item # showing up. I'm trying to get the count of unique stores for each Group Name. I've attached a small sample file that hopefully gets the point across. I tried pivot tabling, but it would return the count every time a store showed up, even if it was the same one.
    Attached Files Attached Files

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