Find Min value and retrieve other field in same record

[#1]

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?

[rwunderlich · Accepted solution]

Try FirstSortedValue()

FirstSortedValue(Date, seconds)

-Rob

[#3]

Hi Rob Wunderlich

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.

[tresesco]

Jay,

It would be better if you create a new thread and post your question there. Generally you won't get much attention in an answered thread. And yes, please explain your expected output.

[#5]

Thanks for your suggestion Tresesco, I will create the new thread with more detail info and expected output