[SOLVED]Ranking

[seahawks3726]

I am making a excell spread sheet for our rodeo. In column B5-B230 are the team Names, In column D is there Time. In Column E I have a macro setup to put a 1-10 on the 10 fastest times.

What i need help with is in Q17 we would like it to show the team name with the fastest time. and then in Q18 show the team with the 2nd fastest time. and so on thru 6th place.

So i guess what i need it to do is either rank column D and if it is Rank 1, show the team name in Q17.

Or else sence I allready have it listing 1 thru 10 in column E, is there a way to make a macro that says if it is 1, then show the team name in Q17, if it is 2, show the team name in Q18..???

any help would be appricaited, thanks