1 Reply Latest reply on Dec 8, 2016 7:46 AM by Shinichiro Murakami

    How to filter out rows of data that don't meet specific criteria

    Alexander Elfering

      Hello,

       

      This is a sample table that I am working with. I am trying to filter the data so that Test Numbers only show up if they have Test %'s filled in all the months selected.

       

      Capture.PNG

       

      I've also attached the workbook I'm working with. Is there a formula that can accomplish this?