I am trying to make an excel file that keeps scores for some events I am having. The problem that I am having is that in this one event I have 2 variables Balloons and time. I am trying to make it so that if you have the most balloons then you get 30 points, 2nd most gets 20, 3rd 10, and the rest 0. If there is a tie for number of balloons I want it to go to time. For an event that is just comparing time, this is what I have: =IF(SMALL(O$4:O$9,1)=O4,1,IF(SMALL(O$4:O$9,2)=O4,2,IF(SMALL(O$4:O$9,3)=O4,3,0))) Can anybody give me a hand with this??

How about something like this... You're awarding a score based on the number of balloons, with the highest score going to the person with the most ballons. In your case, it sounds like 30 would be the highest balloon score. Next, award a score for time, with the lowest score going to the person with the lowest time. In the example below, 1 is the lowest score you can get for time. Now add the balloon score to the time score. The person with the score closest to but greater than 30 must have the most balloons and the shortest time. A B C D 1 Total Name Balloon Time 2 Score Score 3 =SUM(C3:D3) Bob 30 3 4 =SUM(C4:D4) Steve 24 1 5 =SUM(C5:D5) Mary 30 1 This array formula will return Mary, since Mary has the lowest score above 30. {=VLOOKUP(MIN(ABS(A3:A5-30))+30,A3:B5,2,0)} Use Ctrl-Shift-Enter to get the {} around the formula. You can't just type them in.