If have the following array formula to determine the earliest time (Column S) when values in Column G equals G2.
=MIN(IF($G$2:$G$716=G2,$S$2:$S$716))
It works well and as expected. However I want to add an additional condition in the formula. That is where values in Column Q (date column) equal Q2.
I have tried the following :
=MIN(IF(AND($G$2:$G$716=G2, $Q$2:$Q$716 =Q2),$S$2:$S$716))
The result is the minimum value in in column S and not for the conditions I was hoping for.
Any help would be much appreciated.
Bookmarks