If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Finding the lowest cost for a product from a list
I have a list of products with the cost of each (each product appears on the
list multiple times with varying costs). I need to create a formula that will pull the lowest cost for each product into another existing list which displays all the products once. Any help is appreciated. |
#2
|
|||
|
|||
Finding the lowest cost for a product from a list
This is an ARRAY formula that must be entered using ctrl+shift+enter. If
same sht, remove sht reference =MIN(IF(Sheet11!A2:A22=a1,Sheet11!B2:B22)) -- Don Guillett Microsoft MVP Excel SalesAid Software "tt" wrote in message ... I have a list of products with the cost of each (each product appears on the list multiple times with varying costs). I need to create a formula that will pull the lowest cost for each product into another existing list which displays all the products once. Any help is appreciated. |
#3
|
|||
|
|||
Finding the lowest cost for a product from a list
Hi tt,
Since a vlookup will always pull the first instance it finds, sort your list by the product column (or part number or whatever value you are looking up) first, then by the price column in the order of smallest to largest. That way all the items are grouped, the smaller price will be on top, and will be found first. Squeaky "tt" wrote: I have a list of products with the cost of each (each product appears on the list multiple times with varying costs). I need to create a formula that will pull the lowest cost for each product into another existing list which displays all the products once. Any help is appreciated. |
Thread Tools | |
Display Modes | |
|
|