1 Reply Latest reply on Jun 12, 2018 5:17 AM by Zhouyi Zhang

    Arrange this data , delete data you dont need

    AJ.Yusuf

      Hi All,

       

      Hope you are all well. Bit stuck guys need to show only the rows with a data in Either All Three (Ex-Rental,Ex-Business or Private) Or in (Ex-Rental,Ex-Business) or (Ex-Rental,Private). Delete if Data is on its own or not part of Groupinfg

       

      For Example,

       

      Before

       

      What I need is  Only the rows with the yellow square (all data inc the Ex Business and Private ) as thaey have data in the "Ex-Rental Coloumn" the others can be deleted (rows with redline).  (all data inc the Ex Business and Private )

       

      thanks