Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to pull the lowest supplier name
I need assistance creating a formula to extract the supplier name associated
with the lowest supplier bid. A sample of the data looks like this. I need to be careful as some quotes will be zero and I do not want to pull this as the minimum supplier. Sup A Sup B Sup C Minimum Sup Bid Minimum Sup Name $/lb. $/lb. $/lb. $/lb. Item 1 1 2 3 1 ? Item 2 0.5 0.2 0.4 0.2 ? Item 3 2.4 1.9 0.8 0.8 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Supplier Name | Excel Worksheet Functions | |||
Supplier list | Excel Worksheet Functions | |||
Subtotal by Month and supplier | Excel Worksheet Functions | |||
determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
Supplier scorecard | Excel Discussion (Misc queries) |