Excel: Identify the Best Quote
Conditional Format and Minimum Function to Find Best Quote
This video show one way to identify the best price from a range of products and a range of suppliers using conditional formatting and the Minimum Function
This video show one way to identify the best price from a range of products and a range of suppliers using conditional formatting and the Minimum Function