Max Price and Min Price paid for an item - Rephrsed

F

F. GOMEZ

Thanks for your response Rick,
I was really very poor with my explanation but here it is:
I have 2 sheets as follow:
1 with a list af purchases done thru the year showing
Part # Purch Ord # QTY Total Cost Date

The Part # can be received several time during the period range then I setup
the "sheet2" where I summarized all the receiving by part #.
layout of the sheet is as follow:
Part # QTY Total Cost Avg Cost Max Price
Min Price

The part # is unique, Total cost is the summary af all the cost for the
part, QTY is the summary of units received for that part and Average cost is
Total Cost/QTY.
Then my problem is that I do not know how to get the Maximun price paid for
the specific part and the minimun price paid for the same price.

Thanks in advance for your help

Fernando
 
A

Ashish Mathur

Hi,

You can use the following array formula (Ctrl+Shift+Enter)

=max(if((part#range=part#cell),totalcostrange))
=min(if((part#range=part#cell),totalcostrange))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Max Price and Min Price paid for an item 1
Merging duplicate lines in a Database 1
How can I combine data from two sheets where field contents match? 6
Pivot table: Most recent price for an item? 3
Problem with a conditional Min formula 1
Find Last entry for Col in Multi column array using cell from another array. 1
Solution for if x = 1 and Y =2 goto C3 2
Guidance/Help to Highlight Cell contentts Based on Min/Max 2

Top