|
Max Price and Min Price paid for an item - Rephrsed
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 |
Max Price and Min Price paid for an item - Rephrsed
|
Max Price and Min Price paid for an item - Rephrsed
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 "F. GOMEZ" wrote in message ... 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 |
Max Price and Min Price paid for an item - Rephrsed
Thanks a lot.
This formula definetly works perfect. "Ashish Mathur" wrote in message ... 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 "F. GOMEZ" wrote in message ... 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 |
Max Price and Min Price paid for an item - Rephrsed
You are welcome.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "FERNANDO" wrote in message ... Thanks a lot. This formula definetly works perfect. "Ashish Mathur" wrote in message ... 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 "F. GOMEZ" wrote in message ... 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 |
| All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com