Try this:

C1: =SMALL(A$1:A$50,ROW(A1))

then copy that into C2:C10 to get the smallest, next smallest etc, as
the ROW function will return 1, 2, 3 etc as you copy it down.

Hope this helps.

Pete

On Oct 12, 11:31 pm, zoomzoom632
wrote:
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.- Hide quoted text -

- Show quoted text -