There's a function to do this, and I've used it before, but I'm a numpty and can't recall it or find it via help...
I have a column of best times and a column next to it with the person who made that time. I need to pull out the winner (lowest time, easy just =MIN(Column) but I need to display that person's name, not their time.
So once I've found the min time I need to then determine the name of the person which will be sitting in the cell just next to that winning entry.
Can anyone give me the function name for this? Doesn't matter which package... I'm on openoffice but I can soon find it if it's differently named from excel.
TIA