I am using a MIN Function, but it continues to return "0" for all rows due to blank cells.
These are the formulas I have tried so far:
=MIN(BHS2:BWT2)
=MIN(IF(ISNUMBER(BHS2:BWT2),IF(BHS2:BWT2>0,BHS2:BWT2))) Ctrl+Shift+Enter
=MIN(IF(BSH2:BWT2 <>0,BHS2:BWT2)) + Ctrl + Shift + Enter
All of these formula continue to return a "0".
The numbers in the data set run from 1-17 with no 0, but many blank cells.