Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Conditional Count Unique (2000 SP3)

    Hi,
    Attached is a sample spreadsheet showing my problem.
    I need to know, how many post titles of a certain colour there are in each section of my organisation.
    The green highlighted cells work fine, they tell me how many posts there are in each section broken down by Red/Green. BTW I wouldn't have even got that far had it not been for this forum, thanks guys.

    I know the formula for counting the number of uniques in a list, but I need to combine it with the colour condiition. The yellow highlighted cells show the answer I need.

    Basically, how can I combine the "unique count" formula with the red/green and section condition to tell me how many different green post titles are there in each section.

    Thanks
    Jim MacLeod
    Shetland Isles
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Count Unique (2000 SP3)

    There are probably better ways, but in the attached version of your workbook, I created a clunky custom VBA function to calculate the unique count of titles.

    (Personally, I'd use queries in Access for this type of problem)
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Conditional Count Unique (2000 SP3)

    Fantastic!

    I thought it MIGHT be possible with loads of nested ifs and arrays but couldn't get my head around that.

    I started to code something similar but gave up on page 2! This is a really neat & flexible solution that will really help in other things I do.

    Yet again... thanks Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •