Results 1 to 7 of 7

Count the number of Unique Items in a Column for each Unique Item in another Column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Count the number of Unique Items in a Column for each Unique Item in another Column

    Is there any way to do a count of the number of unique items in Column B for each unique item in column A without using a helper column and a Pivot Table.

    I'm using this formula in a helper column follwed by a pivot table to give me the results. I'm trying to achieve the same result without either the helper column or the pivot table in the attached sample.

    =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1)
    Many thanks
    Attached Files Attached Files
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-09-2015, 05:19 AM
  2. [SOLVED] How can I count unique items in a filtered column?
    By terry_believers in forum Excel General
    Replies: 11
    Last Post: 07-12-2012, 09:52 AM
  3. counting number of unique items in column
    By maacmaac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2008, 02:17 PM
  4. Count unique items in column.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2008, 10:14 AM
  5. [SOLVED] RE: How do I set up a formula to count only unique items in a column?
    By jennifer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2006, 07:10 PM
  6. [SOLVED] How do I set up a formula to count only unique items in a column?
    By LYLERR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2006, 07:10 PM
  7. [SOLVED] Count number of unique items in a column that contains duplicates
    By Steembeem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2005, 09:06 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