Forum Discussion
Solved
MINIFS function
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 ...
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.
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.