I am using a Min IF Function on a number of rows.....
=MIN(IF(A:A=[Cell Number],M:M))
If the value of cell number does not appear in column A I generally get a "N/A" result.
However on one example I am getting a 0 result.
Would any one know why this would occur?... the cell value definitely doesn't appear so I am at a loss!
Can pull together sample data if required. Thanks.
Bookmarks