Laura,

If your data is in A1:A25, you can use
SMALL($A$1:$A$25, 2) to find the second smallest value. Bij changing the
value of 2 you can find 3th; 4th etc. smallest values.
SMALL($A$1:$A$25,1) is equivalent to MIN($A$1:$A:$25)



--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Laura" wrote in message
...
I have 5 worksheet tabs within the same spreadsheet. Each
tab has two columns with a beginning date (col A) and
ending date (col B). I.e.

Beg Date End Date Amt
11/24/03 1/14/04 $100
1/15/04 7/14/04 $150

etc.

The beginning and end dates are not the same for each tab.

I would like to create a summary that goes through all the
beginning dates and identifies the smallest date, the next
smallest date etc. to create one summary of all the dates.

MIN and MINA indentify the first smallest date, however, I
am unable to identify the next smallest date.

Is this possible? Thank you.