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 (h) |
| Oakland | |
| Seattle | |
| Tacoma |
But when i use DMIN function the result shown for oakland is 4 instead of 6.
I am using office 365.
6 Replies
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.
- Hi, I'd starting looking for trailing spaces... I guess there is a space after Oakland in the row with the 4... Kind regards Hans
Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
Rather the function results in Value Error
