2 Replies Latest reply on Sep 20, 2018 1:23 PM by Rod Nault

    Row Filtering Assistance Requested

    Rod Nault

      I am having a challenge filtering out specific rows.  Of 12 audits completed, Blue has 12 values out of 12 audits and Green only has 8 values for the 12 audits.  I want to see only the 8 values for Blue that correspond to the 8 audit values for Green.  How do I filter out the 4 Blue audit values without removing any of the other data?  The challenge is that I can not pivot the data as I need it the way it is to facilitate other reporting requirements.  In my actual dataset there are thousands of records.  The end result would have both blue and green with a count of 8.  Packaged workbook attached.

       

      What formula can I use to accomplish this?

      Rod