0 Replies Latest reply: Sep 13, 2017 1:31 AM by Neha Pathak RSS

    Need Help in Logic

    Neha Pathak

      I have a requirement in which I need to add values for duplicate employee Id's

      and then map that added value and emp id  in another excel sheet

       

       

      eg-In my sheet I have 2 columns Emp id and Days I need to add days by grouping the empid

      Employee id 101 is present in my sheet 3 times and each having some value for days

      empid    days

      101         7

      102         8

      103         6

      101         5

      101         8

      103         10

       

      so it should give

      Empid     total_days

      101          20

      102          8

      103         16

       

       

      After grouping the emp id's I need to map these id in another excel sheet which has unique empid.