Aug 10 2021 09:03 AM - edited Aug 10 2021 09:04 AM
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?
Aug 10 2021 09:15 AM
SolutionAs 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.
Aug 10 2021 09:15 AM
SolutionAs 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.