Hi,
I have managed to get the array to work using
{=MIN(IF((A2:A12=E2)*(B2:B12=F2),C2:C12))}
However, it is taking the "blank cells" as "zero" as the minimum values. How do I write it so that it will ignore the blank cell? And how to write it if trying to get it to ignore "zero" values?
If someone can help me... I really appreciate it.
Thank you in advance.
Joey
Bookmarks