I can see now that the helper coloumn and the formula use Kennett OR Sun Valley based on a value of "1" in H2:H21, And I think that would be fine for 1st and 2nd place. 3rd-6th need the same school distinction and they should be the times from small to large EXCLUDING the times for 1st and 2nd AND can be from any heat# I hope that helps to clarify it a bit...
Bookmarks