How to filter by greatest of

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)> schrieb im Newsbeitrag
news:D[email protected]...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to ignore a column of numbers in Grand Total for rows 1
Pivt or grouping or some other means to summarize data 2
Find last date of sold stock and sold price. 2
Sumproduct with filters 7
What's the best way to set this formula up? 0
averages without zero 6
Help with countif and sumif functions 8
combobox uses query - filter set by checkbox ? 3

Back
Top