Hello:

I am designing a MIN/IF formula that draws on an Excel Table.

{=MIN(IF((Fuel201207[[ Vehicle]] =A5)*(Fuel201207[ [ Odometer] ]<>0)*(Fuel201207[ [ Date] ]>=$G$1)*(Fuel201207[ [ Date] ]<=$H$1),Fuel201207[ [ Odometer] ]))}

Each record is a fuel transaction that includes an [Odometer] reading. Since this data is entered on a keypad in the field, there are multiple errors (extra or omitted digits) and non-entries ("0's"). Is there a way to eliminate the anomalous data at the table level or possibly the formula?

Thanks in Advance--