5 Replies Latest reply on Jan 3, 2015 4:16 PM by Naquiyah Cash

    Filtering to show only Unique records

    Naquiyah Cash

      Hi All

       

      Is there an easy way to filter the unique records. I would have thought this was simple but can't find a simple solution.

       

      Below I have 3 As , 2 Bs and 1 C. I want the total result for all to be 10 as its taking the unique one record and ignoring duplicates.

       

      Ive attached a workbook

       

       

      Screen Shot 2014-12-22 at 4.30.16 PM.png