M
Mark McDonough
Following up on a previous query..........I am able to look along a row of
values and return the name of the cheapest supplier thanks muchly toJohn
Topely and Bob Philips.
To obtain the name of the supplier I tried
=INDEX($B$1:$E$1,1,MATCH(MIN(IF($B2:$E2>0,$B2:$E2)),$B2:$E2,0))
as suggested and it works well.
Extending on that idea, how would I go about returning the name of the
supplier that had the next cheapest rate and the third cheapest given that I
have 24 suppliers. For the purpose of illustration, I have only shown 3 in
my example.
Site Supplier A Supplier B Supplier C
Bilo1 175000 150000 125000
Bilo2 125000 50000 60000
Bilo3 50000 60000 70000
Any help appreciated
Cheers
Mark
values and return the name of the cheapest supplier thanks muchly toJohn
Topely and Bob Philips.
To obtain the name of the supplier I tried
=INDEX($B$1:$E$1,1,MATCH(MIN(IF($B2:$E2>0,$B2:$E2)),$B2:$E2,0))
as suggested and it works well.
Extending on that idea, how would I go about returning the name of the
supplier that had the next cheapest rate and the third cheapest given that I
have 24 suppliers. For the purpose of illustration, I have only shown 3 in
my example.
Site Supplier A Supplier B Supplier C
Bilo1 175000 150000 125000
Bilo2 125000 50000 60000
Bilo3 50000 60000 70000
Any help appreciated
Cheers
Mark