Minimum array formula.

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.
 
B

Bernie Deitrick

Don't use the 0s as the conditional returns:

=MIN(IF(A10:A300=Title,IF(B10:B300>0,C10:C300)))


HTH,
Bernie
MS Excel MVP
 
T

Teethless mama

Try this:

=MIN(INDEX(10^10-(A10:A300="Title")*(B10:B300>0)*(10^10-C10:C300),))

Just press Enter
 
C

Confused_Euffy

Thank you Bernie, this worked perfectly.

Thank you to Mike and Teethless mama as well, but I must admit I couldn't
get either of those to work, but thank you anyway. It may be that I haven't
paid enough attention to them.
 
S

Shane Devenshire

Hi,

You might also try

=MIN(IF((A10:A300=Title)*(B10:B300>0),C10:C300))

Entered as an array

If this helps please click the Yes button

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top