How to filter by greatest of

  • Thread starter Ruthless Techno Wienee
  • Start date
R

Ruthless Techno Wienee

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.
 
B

Bart Snel

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
 
Top