Find the row of the minimum value based on one condition

Still with Excel 2016? I think not if you are using MINIFS - please update your profile.

The problem is you are matching only the minimum value. Try this instead:

=MATCH(1,(C:C=MINIFS(C:C,A:A,"<>"&1))*(A:A<>1),0)

Another way

Formula:

Please Login or Register  to view this content.

Edit Formula in post#2 can NOT be simplified to =MATCH(1;(C:C=MIN(C:C))*(A:A<>1);0)

Formule in Post#3 returns zero if the minumum value in Colum C only exists if A=1. That happens when you cel C2 turns in 1.
I made the same mistake in post #4.

I was thinking the same, on second thought

Thanks all, both options work - and yes I still use 2016 on my personal PC

There were three - did you try mine?

MINIFS does not work in Excel 2016, so you should have said in your opening post which version this particular solution was for.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.