Now for the Second Part.

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this makes sence.

"zoomzoom632" wrote:

Here's the Senario,

Sheet One Contain the Results of a Race:
Column A: Racers Name (in ABC order)
Column B: Their Hometown
Column C: Their Time
Column D: Their Heat Number

On Sheet 2 I want to have the spreadsheet seach for the proper infomation
from sheet 1.
The Colums are the same, and here, the row numbers represent the place number.

In Column C, I want it to find the lowest time first, then in the 2nd row,
find the 2nd lowest time, ect.

In the other three column, I want it to match the data listed next to the
time from sheet one, in their appropriate columns.

I hope you can figure out what I mean.

Thank you.