Forum Discussion
Unable to derive value for DMIN Function
Hey there, I have the following dataset City Times (h) Seattle 5 Tacoma 8 Oakland 9 Seattle 4 Tacoma 10 Oakland 6 and require min for following City Times...
According to https://support.office.com/en-us/article/dmin-function-4ae6f1d9-1f26-40f1-a783-6dc3680192a3, 4 is the correct answer as it Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify. In the example found at the bottom, it is shown to be an OR conditional. Meaning return me the smallest number in Times(h) where the record is Oakland OR Seattle OR Tacoma.
I think you would be better off MINIFS:
=MINIFS($C$3:$C$8,$B$3:$B$8,E3)
Yes Sir,
I was working with DMIN function.
I found out that DMIN function doesn't handle two results simultaneously.
I have selected 3 results simultaneously so, the result was the min of all cell.
Thanks for the MINIFS function.