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
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
Site Supplier A Supplier B Supplier C
Bilo1 175000 150000 125000
Bilo2 125000 50000 60000
Bilo3 50000 60000 70000
Any help appreciated
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----