4 Replies Latest reply on Jul 30, 2018 10:56 AM by Jim Dehner

    how to do a count if mulitple rows per ID contain "yes" all values will be "Yes"

    Kelly C

      Unfortunately I can't attach a packaged workbook since I'm dealing with confidential info but here's a snippet to help explain.

       

       

      So what is not shown is a field to the left of these columns which is a unique ID.  My goal is to be able to write a calculation to say if there is a Yes for a unique ID (since some of the unique IDs have both a Yes and No) can we translate that entire row to just "yes".  I basically just need one answer per unique ID and if one of the rows per Unique ID has a yes, all should be yes.  If No, all are no.  Hoping this wasn't too confusing....thanks!