Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    London, Gtr London, England
    Thanked 0 Times in 0 Posts

    Count based on two conditions

    Dear loungers

    Some time ago "Retired"Geek gave me this solution to wanting to create summary figures based of two conditions.

    I have used this principle a lot and it works well. however, if you have a large number of categories to summarise - i have a matrix of 25 categories by 6 status values it is a little unwieldy -if only in the setting up, and pray that some bright spark doesn't suggest another status value. So I am wondering if there is another way to do this?

    Thank you...................... liz
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Manning, South Carolina
    Thanked 1,454 Times in 1,323 Posts

    How about a simple pivot table?

    P.S. Your sample data had "raised" and "raised " which caused two columns to appear when I first tried it. You have to be careful with leading and trailing spaces. It would be a good idea to use data validation to prevent this.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by RetiredGeek; 2012-11-05 at 11:06.
    May the Forces of good computing be with you!


    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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