Try a Pivot Table:

First, make sure your table has column headings
(exampe: A1: MyNumber, B1: MyDate)

<Data<Pivot Table
Use: Excel
Select your data range
Click the [Layout] button

ROW: Drag the MyNumber field here
DATA: Drag the MyDate field here
Dbl-click it and set it to Max
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each MyNumber and the Max of dates for each MyNumber.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


" wrote:

I would like to see the unique values from column A, where Column B is
a max() for that value in A. For example, in Column A there are
several 1's, I would like to see the max of column B, where column A is
a 1, and the same thing repeated for all the other unique values in
column A.

INPUT:

A B
1 07/22/05
1 08/26/05
1 10/11/05
2 11/04/05
2 01/04/06
2 07/22/05
3 08/26/05
4 10/11/05
4 11/04/05

The output I'm looking for would look like this:

A B
1 10/11/05
2 01/04/06
3 08/26/05
4 11/04/05