MINIFS function

[sp3124]

Hello,

I have data in the below form :

ID	Time
1	08/04/21 23:11:00
1	08/04/21 22:49:00
1	#VALUE!

When I use the Minif function to get the min time for this id, I am getting the answer as #Value!. However, I want to get the minimum time instead of the #value!. Is there a way I can make this work using the MINIF function?

[#2 · Accepted solution]

@sp3124 

As an array formula confirmed with Ctrl+Shift+Enter:

=MIN(IF(($A$2:$A$100=D2)*ISNUMBER($B$2:$B$100),$B$2:$B$100))

where D2 is a cell containing the ID you're looking for.

Adjust the ranges as needed.