2 Replies Latest reply on Jan 30, 2014 9:01 AM by marketa.bilska

    How to remove NULL from Quick Filter? Deleting Excel rows, creating set and duplicate is not working.

    marketa.bilska

      Hello,

       

      I was wondering if someone could help me remove NULL option from my Quick Filter for the Year variable? I tried all solutions suggested online: delete rows/columns in the original Excel data sheet (didn't work), create a duplicate of the Year variable to exclude the NULL (didn't work), and create a set (it was greyed out so I couldn't use it as filter) - but even when I create the set, it shows only 3 values (2011, 2012, 2013) but when I show the Quick Filter, the NULL is there.

       

      I'm attaching the workbook with sample data - I think that using the UK map there may be causing these problems.

      I'd be grateful for any help!

       

      Thanks in advance

      Marketa