Finding the lowest cost for a product from a list
in [Functions]
|
From: tt on 16 Apr 2010 10:58 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.
From: Don Guillett on 16 Apr 2010 11:13 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 dguillett(a)gmail.com "tt" <tt(a)discussions.microsoft.com> wrote in message news:E973CAB7-86C1-46AC-B5FD-FF47F21A0F88(a)microsoft.com... >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.
From: Squeaky on 16 Apr 2010 11:30 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.
|
Pages: 1 Prev: Using text and formatting sum function in formula Next: Dynamic Filtering...Need Help |