C
Confused_Euffy
Can anyone help me please.
I am trying to find the minimum figure (excluding zeros) from a column using
an array formula. My formula is as follows:
=MIN(IF(A10:A300=Title,IF(B10:B300>0,C10:C300,0),0))
The figures in column c are formulas driven from another tab, and the title
is a drop down list to choose job titles. For some reason my formula always
returns a minimum of zero when zero's are present.
Hope this makes sense.
Can anyone help, it's driving me insane?????
Many thanks in advance.
I am trying to find the minimum figure (excluding zeros) from a column using
an array formula. My formula is as follows:
=MIN(IF(A10:A300=Title,IF(B10:B300>0,C10:C300,0),0))
The figures in column c are formulas driven from another tab, and the title
is a drop down list to choose job titles. For some reason my formula always
returns a minimum of zero when zero's are present.
Hope this makes sense.
Can anyone help, it's driving me insane?????
Many thanks in advance.