Tuesday, May 21, 2013

yogi_Sort Swimmers By Their Event Time Delineated In Minutes Seconds And Hundredths Of Seconds In Ascending Order

                                          Google Spreadsheet   Post  #1206
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 21, 2013
user Cole Varner (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!category-topic/docs/spreadsheets/Qv36Uvf-ApE)
How to attach names to the output of sort()
Hello there.
     So basically I have a list of people with race times associated with each. There are many different events and not all swimmers have times for all events. it looks sort of like the following

                        event1      event2       event3
swimmer1        1:00.00      1:55.00      2:05.00
swimmer2        59.50                         2:00.00
swimmer3        1:05.10      1:50.00      1:59.00

using the following formula I figured out how to sort the top 10 times per events into a new list

=sort(filter(C3:C15, C3:C15<=small(C3:C15, min(10, count(C3:C15)))))

all the C's have to be changed for each new event.

anyway my question is how to attach the name of each person to the output of filter/sort so it looks like this:


59.50 swimmer2
1:00.00 swimmer1
1:05.10 swimmer3
I assume that you are showing the times in minutes seconds and hundredths of second ... with that
let us have a look at the