4 Replies Latest reply: Mar 11, 2014 2:29 AM by jay chen RSS

    Find Min value and retrieve other field in same record

      I have a CSV file containing activities where each activity has a time (seconds) and date associated with it. I want to show the activity with the shortest time and it's corresponding date in a text box. I can find the shortest time by using the Min function, but how do I get the corresponding date?