| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Max Price and Min Price paid for an item - Rephrsed
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max Price and Min Price paid for an item | Excel Worksheet Functions | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| Most recent price per item | Excel Worksheet Functions | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Linear Mode
