9 Replies Latest reply on Aug 30, 2016 12:37 AM by Shriram Saxena

    Removing rows with NULL data?

    Anirudha Porwal

      Hi, I have a situation here where I need to remove those rows which do now possess any data for Current Quarter i.e., no entry for current quarter is present. My data Set is as below:

      DataSet.jpg

      Here i want to compare Current and Previous Quarter sales (assuming current Qtr as Q2-2016). i want only those departments which have some value of sales (may be zero). I want only Departments B and C in output as below:

       

      Output.jpg

      Attaching sample excel data file.