Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max Price and Min Price paid for an item
I have a report from database giving me purchases at different unit prices,
I am trying to get the maximun price price paid in 1 column and the minimun price paid in another column, my datebase is about 5000 items. Your help is very much appreciated. My sheet layout is like this: A B C Part # Qty Unit Price Fernando |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table: Most recent price 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) |