Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimum function in a list
Hi Guys,
Please can you help? I have a transaction sheet where I capture all purchases of different items with the quantity, price and supplier of the goods. I also have created a summary sheet which then uniquely lists the items purchased and it attempts to summarize these purchases from the transaction sheet. In this summary table I would like to get the min price paid for the particular list item, the supplier and date of this minimum price purchase. Please can you supply me with a formula or the VB code? While I am asking... Also in the transaction sheet I have a column for "transaction type" (Opening stock, closing stock and purchases). My idea is to keep a trck of stock on hand and useage in the summary table. Currently I have a column for each (openning stock + Purchases - Closing stock). Obviously there is a problem as the closing stock for the one month needs to become the openning stock of the next. Can someone point me in the right direction? Thanks Albert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the minimum and maximum date in a list | Excel Programming | |||
Minimum Ifs Function | Excel Worksheet Functions | |||
Minimum function | Excel Discussion (Misc queries) | |||
minimum function | Excel Worksheet Functions | |||
How to subtract two lowest minimum scores from list | Excel Programming |