• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    The formula I have used is =SUM(IF(Resolution="01 - Student Conference/Warning",1/COUNTIF(Resolution,"01 - Student Conference/Warning",Student,Student))). I enter as an array formula , using CTRL SHIFT ENTER.
  2. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    I finally got back to my spreadsheet and your formula worked but I have run into another problem with the #NAME? error that really has me baffled. I am trying to find the number of students that have received a particular resolution. I am copying and pasting a portion of the spreadsheet here...
  3. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    Are there any sort of restrictions on the data names for the formulas to work? My behavior types are like "01-01 Behavior Detrimental to Learning". They are a combination of numbers and text and begin with numbers. I know the formula is not working because of something like this problem.
  4. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    I am using 2007. Thanks for the spreadsheet. I am analyzing mine now to see where my problem lies.
  5. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    THANKS, Narayan, for your help BUT I am getting a #NAME? error. I am using your exact formula and CTRL SHIFT ENTER but to no avail.
  6. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    So can you help me with a formula on my problem?
  7. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    If I did my pivot table as you suggested, then it counts a unique student more than once. Each student can only be counted once.
  8. B

    Count Unique Values Associated with Unique Values with Multiple Criteria

    Using the table below, I want to count the race of the unique students who have a referral for Disrespect. Each student only gets counted once even if they have multiple referrals so the race will only be counted once. There are 4 unique students that have a referral for Disrespect. There...
  9. B

    Need Formula to Count Unique Number in a Column Using Partial Criteria

    THANKS! The problem was the blank cell issue.
  10. B

    Need Formula to Count Unique Number in a Column Using Partial Criteria

    Yes I am new at this Excell stuff. So here is my formula: SUM(IF(ISNUMBER(FIND("Out-of-School",D:D)),1/COUNTIFS(D:D,"*Out-of-School*",A:A,A:A))) I am getting a error of division by zero. What am I doing wrong?
  11. B

    Need Formula to Count Unique Number in a Column Using Partial Criteria

    I am trying to get a formula that will return the following result. If column D shows "Out-of-School" anywhere in the cell, then I want to count the number of unique students that have a resolution stating "out-of-school". For this particular set of data there are 3 unique students that have a...
  12. B

    Partial Criteria Returning Count of Unique Values

    I want it to simply work for this week. Assuming that this is one week and I am not using dates (only days of the week), how can it work?
  13. B

    Partial Criteria Returning Count of Unique Values

    I am trying to get a formula that will return the following result. If column B shows "Out-of-Town" any where in the cell, then I want to count the number of unique employees that are out-of-town at any time during that week. For this particular week there should be 2. The problem I have is...
Back
Top