| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to calculate Latest Cost (inventory valuation)
I have a worksheet that contains the daily purchases for 4 products.
column B contains the products column D contains the purchase price column K contains the division column J contains the day of the month I need a formula that will pull the latest purchase price by product by division. In other words the last purchase for the month and the associated purchase price. Thanks -- col |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a total cost chart where a component cost is a step cost | Charts and Charting in Excel | |||
| inventory Add, Cost, Sold, Sold price - formula | Excel Discussion (Misc queries) | |||
| Calculate X1-5 and Y? If total cost is given. | Excel Discussion (Misc queries) | |||
| Factors governing Inventory Cost Calculation at dealership | Charts and Charting in Excel | |||
| Urgent! Somebody Pleez help!! Inventory Valuation | Excel Worksheet Functions | |||
![Curtis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
