3 Replies Latest reply: Dec 19, 2017 5:18 AM by Никита Смирнов RSS

    Minimum among previous

    Никита Смирнов

      Hi!

      I really need your help

       

      For examle I have a table:

       

       

       

      [Letter, Number, date
      aaa,5,9

      bbb,4,9
      aaa,7,10

      bbb,3,10
      aaa,1,12

      bbb,3,12
      aaa,6,13]

       

       

      For each letter I need to get a minimum among previous days

      So it would be:

      [Letter, Number, date, Min
      aaa,5,9, -

      bbb,4,9, -
      aaa,7,10, 5

      bbb,3,10, 4
      aaa,1,12, 5

      bbb,3,12, 3
      aaa,6,13, 1]

       

      How can I do that?

      Thanks in advance