4 Replies Latest reply: Jun 22, 2015 5:10 AM by reshma paturi RSS

    Loading only the maximum value to every cell in a column

      Dear community,

       

       

      I have a case where I need to create a column the maximum value that is in another column.

       

      The data looks like this:

       

       

      DateData
      01.01.2015100
      01.01.2015200
      150
      01.01.2016100
      120
      01.01.2018130
      140
      01.01.2015170

       

       

       

      The goal is to get a column with the max date in every cell:

       

       

      DateData
      01.01.2018100
      01.01.2018200
      01.01.2018150
      01.01.2018100
      01.01.2018120
      01.01.2018130
      01.01.2018140
      01.01.2018170

       

       

      I have a big data set and multiple sheets, so I need to make the operation nice and easy.

       

       

       

      Thank you guys!