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