From: Cassius on 4 Jun 2010 13:04 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 ?
From: Luke M on 4 Jun 2010 15:20 To get the minimum and ignore zeros, can use this array (confirm formula using Ctrl+Shift+Enter, not just Enter) formula: =MIN(IF(B3:D3>0,B3:D3)) To get Supplier name: =INDEX(B$1:D$1,,MATCH(E3,B3:D3,0)) -- Best Regards, Luke M "Cassius" <Cassius(a)discussions.microsoft.com> wrote in message news:1C640168-10C0-4EF4-843A-FDBD3819BC76(a)microsoft.com... >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 ? >
From: Don Guillett on 4 Jun 2010 16:15 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 dguillett(a)gmail.com "Cassius" <Cassius(a)discussions.microsoft.com> wrote in message news:1C640168-10C0-4EF4-843A-FDBD3819BC76(a)microsoft.com... >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 ? >
From: Don Guillett on 4 Jun 2010 18:40 I meant If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:OPQd$KCBLHA.4500(a)TK2MSFTNGP02.phx.gbl... > 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 > dguillett(a)gmail.com > "Cassius" <Cassius(a)discussions.microsoft.com> wrote in message > news:1C640168-10C0-4EF4-843A-FDBD3819BC76(a)microsoft.com... >>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 ? >> >
|
Pages: 1 Prev: Multiple IF's with an OR Next: iserror and ifs nested formulas |