Hi !! Hope you geniuses can help me.. this is driving me crazy.
I need to find the smallest number in column "d", but only if the corresponding row, column "a" = yes.
for example:
so, in this instance i need a formula to bring back the number "2", since its the smallest number that appears on the same line as "yes"..A l B C D
1 yes x o 3
2 no x o 1
3 yes x o 2
4 yes x o 4
I've tried other formulas, but they keep bringing back "1".
Thank you sooo much!!!
Bookmarks