6 Replies Latest reply on Oct 23, 2018 10:02 PM by krishna kanth

    Sheet level comparison of a particular Column

    krishna kanth

      Hi Folks,

       

      here i have 2 sheets where Sheet 1 consists of top 5  products in a State that are in  trending as per sales (State wise top 5)

       

      Product id
      Product name
      Store code
      Net Sales

       

      Sheet 2 consists of Store wise top 5 products as per sales (Store wise top 5)

       

      Product id
      Product name
      Store code
      Net Sales

       

      In Sheet 3 i would like to compare Sheet 1 product id's And Sheet 2 Product id's and i want to display the Product id's list which are not Present sheet 2

      (Store wise top 5 Products)  but present in sheet 1 (State wise top 5 Products)

       

      EX:

      Sheet 1

      Product Id
      100A
      200A
      300A
      400A
      500A

       

      Sheet 2

       

      Header 1
      300a
      400A
      600A
      500A
      700A
      800A

       

      SHEET 3 (Desired Output)

      Header 1
      100A
      200A

      Any help here would be really appreciated.