2 Replies Latest reply on Dec 4, 2018 2:32 AM by AJ.Yusuf

    Find the Min or Max which is greater then a Certain value

    AJ.Yusuf

      Hi All

       

      I have a data set whch has "DATETIME of Count field"

      I would like to look in the "Time of Movement" field and find the next time whcih grater then the "DATETIME of Count field" AND THE GREATEST TIME before

       

      for example

      For the Number = AF65VEO"

       

      The time of the movement after the "datetime of count" field =20/11/2018 16:30:00

       

      So Name = Ste

       

      and the time before is

       

       

      I would like to identify this for a large amounbt of records

       

       

      is it possible to get a simple wortksheet with

       

      above example

       

      Number           Name before Count     Name After count

      AF65VEO           Ste                                   Uni