I have approx 600 unique items on about 10,000 rows that have sold by various
prices. I want to be able to filter all except the "last sold" price. Date
criteria is in spreadsheet. I need to be able to look at the item, and "get"
only the last sale information.

Hi
maybe post some more details about your data layout and maybe post some
example rows of data

--
Regards
Frank Kabel
Frankfurt, Germany

"Ruthless Techno Wienee" <Ruthless Techno
schrieb im Newsbeitrag
...
I have approx 600 unique items on about 10,000 rows that have sold by
various
prices. I want to be able to filter all except the "last sold"
price. Date
criteria is in spreadsheet. I need to be able to look at the item,
and "get"
only the last sale information.

Say you have three columns, Item, Date & Price

Data / Subtotals
For each change in Item
Use Function MAX
Add subtotal to Date

Good luck!

Bart Snel

"Frank Kabel" schreef in bericht
...
Hi
maybe post some more details about your data layout and maybe post some
example rows of data

--
Regards
Frank Kabel
Frankfurt, Germany

"Ruthless Techno Wienee" <Ruthless Techno
schrieb im Newsbeitrag
...
I have approx 600 unique items on about 10,000 rows that have sold by
various
prices. I want to be able to filter all except the "last sold"
price. Date
criteria is in spreadsheet. I need to be able to look at the item,
and "get"
only the last sale information.