I placed the "new" table in columns F to H on the same sheet and used the
following, starting in row 2:

F2: =LARGE($A$2:$A$8,1)
G2: =INDEX($B$2:$D$8,MATCH($F$2,$A$2:$A$8,0)+ROW()-2,1)
H2: =INDEX($B$2:$D$8,MATCH($F$2,$A$2:$A$8,0)+ROW()-2,3)

Copy down to F5

HTH


"Pierre" wrote:

Have a pricing ordeal:

Prices are organized as follows on data tab:

Date Min Max Price
1/25/04 5 9 11.50
1/25/04 10 24 9.85
1/25/04 25 99 6.50
6/16/06 5 9 13.80
6/16/06 10 24 11.00
6/16/06 25 99 8.50
6/16/06 100 249 6.35


Am looking to create a table on a price tab, populating the most recent
dates and
all 4 price breaks(and the figure from the min column which can
change).

Result would be on price tab:

Date Qty Price
6/16/06 5 13.80
6/16/06 10 11.00
6/16/06 25 8.50
6/16/06 100 6.35

Note: Dates in the data tab are grouped in chronological order
by date, and ascending by quantity.


TIA for your interest and help.

Pierre