I have several worksheets which contain pricing data. I want to find the lowest price and display the price and name of company. Couple of problems:
1. How do ignore $0.00 values?
2. How d I display the name of the sheet (ex:if lowest price is found on sheet named "company B")