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 ? |
#2
|
|||
|
|||
Formula to pull the lowest supplier name
To get the minimum and ignore zeros, can use this array (confirm formula
using Ctrl+Shift+Enter, not just Enter) formula: =MIN(IF(B330,B33)) To get Supplier name: =INDEX(B$1$1,,MATCH(E3,B33,0)) -- Best Regards, Luke M "Cassius" wrote in message ... 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 ? |
#3
|
|||
|
|||
Formula to pull the lowest supplier name
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 ? -- Don Guillett Microsoft MVP Excel SalesAid Software "Cassius" wrote in message ... 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 | |
|
|