I have a pricing sheet that compares a current Supplier to Potential Supplier's prices. I'm attempting to output lowest 3 prices compared to current pricing to facilitate selecting a supplier for ordering products. In my data entries I won't have prices from all vendors...thus a BLANK or a Zero(0). This is giving me Zero(0) outputs for the low price. Is there a solution to my problem ?....or do I need a different approach ? I know just enough Excel to manage some simple uses of Excel. Thank you in advance for assistance !!!!! (Sample File Attached)
Bookmarks