Hello.
I want to find all instances where there is an 'A' in colum A and the smallest number in column D. In other words, both of those conditions must be true.
The result in the first row (F2) shows only one condition to be true and returns 2.8 and I would like it to return a '0'
The result in the second row (F3) shows both conditions as true and returns the smallest number which is correct (1.46)
So, when both conditions are true, I want to see the smallest number in column F. Otherwise, I'd like to see a zero in column F
Thank you.
https://docs.google.com/spreadsheets...it?usp=sharing
Bookmarks