finding appropriate supplier name in table with articles, suppliers and their prices
Posted by rudi holans on March 27, 2001 3:03 AM
Situation: table left columm: article codes - top row table = supplier names - data = article prices. - I can find the cheapest, 2nd cheapest,.... from the table per row, but now I also need to add the name of the supplier that has the 2nd best price, 3rd best price,.... Which formula do I need to do this. The table has more than 50 columms.