Hi,

You can also try with sort the table it will the exactly what you have
mentioned below.

Data|sort|choose the criteria date wise & then item wise
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Jack" wrote:

I have a list of items and would like to select the data based on type.

my data is setup like this

A B c
Meal 2/1/08 $3.00
Meal 2/2/08 $5.00
Airfare 2/5/08 $40.00
Taxi 2/3/08 $23.00
Meal 2/3/08 $3.00


i would like to read the data have it displayed on another part of the
spreadsheet
K L M

Meal 2/1/08 $3.00
Meal 2/2/08 $5.00
Meal 2/3/08 $3.00



thanks

jack