Sorry Everyone, I know this one has been on here a dozen times, but I cant
find any relating posts.

Say I have 2 columns and 4 rows of data such as:

A B

1 2800 $2000

2 2700 $1952

3 2940 $1700

4 2852 $2100


I want the next 3 rows to sort this from smallest to largest according to
value in column A. I have a fixed # of data points (3 in this example) and
would like to use formulas rather than the sort command so that I can have a
x-y scatter plot of the sorted data that updates automatically when ever new
data is entered up in rows 1-3. So the new data should look like this:

A B

5 2700 $1952

6 2800 $2000

7 2852 $2100

8 2940 $1700

I know this can be done with the vlookup for the column b part once I have
ranked column A, but I don't know how to find the 2nd largest (or nth
largest) or 2nd smallesst value. In reality my sheet may contain up to 15
points so I would like to have a clean formula.

Thanks