Use INDEX/AGGREGATE:

=INDEX(C:C,AGGREGATE(15,7,ROW($C$2:$C$5)/(($A$2:$A$5=F2)*(G2<IF($B$2:$B$5="",NOW(),$B$2:$B$5))),1))

Depending on one’s version this may require the use of Ctrl-Shift-Enter instead of Enter when exiting edit mode.

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top