Is there a formula that will allow me to check the prices of a product in three or more columns find the cheapest and display the cheapest price in an additional column? In addition, once this is done in two separate columns it must identify the supplier name and supplier code.
I constantly compare my supplier prices and would like to be in position where a formula does this and identifies the cheapest supplier, code and price. This would save me tons of time. I can attach an example of what I am attempting to do.