Unable to derive value for DMIN Function

[CA_PUNIT_AGARWAL]

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.

[#2]

Rather the function results in Value Error

[#3]

@CA_PUNIT_AGARWAL 

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. 

[#4]

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

[#5]

No Sir,

@Hans Le Roy 

I got the answer. I was not following the rule of DMIN function.

I got the result.

[#6]

@CA_PUNIT_AGARWAL 

According to DMIN function, 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)

[#7]

@ChrisMendoza 

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.