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?
It seems a long ago topic, but I had the same issue. I tried to use the FirstSortedValue to get the supplier have the min amount in each Producto, but it didn't work. could you please take a look on my attached example.