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
|
|||
|
|||
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 | |
Display Modes | |
|
|