4 Replies Latest reply: Jun 12, 2018 5:00 AM by Sunny Talwar RSS

    Minimum value for a range

    Flemming Bøgh Jensen

      Hi

       

      I want to find the lowest value of "Time" for a given Incident number, where "New Value" starts with "A"  and put it into a new variable in the example below. The number of rows per incident varies.

       

      I have tried RangeMin, but can't make it work... Any suggestions?

       

      Example:

       

      Incident numberNew valueTime
      1A00:39
      1Ax00:45
      2B15:16
      2A15:21
      3B16:05
      3Ax16:06
      3A16:15
      3Bx16:21

       

      Expected output:

      Incident numberLowest value, A*
      100:39
      215:21
      316:06