Comparing worksheets

[ollie0]

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")

Thanks.

 

[nbrcrunch]

Say the following exists in cells a1:a6

3
0
1
7
8
10

Formula in a7: =MIN(IF(B1:B6 <> 0,B1:B6,""))

Entered as array formula (Ctrl-Shift-Enter) will give you the answer "1" as the lowest number excluding zero.

 

[nbrcrunch]

Regarding sheet id:

If all your pricing is in a single column in each sheet, then, as a simple solution, you could create another sheet that puts each price column from source sheets into a single column on the new sheet. That way, you can run your minimums easily and see which column contains the minimum value.