LinkBack URL
About LinkBacks
Try this in H2:
Confirmed with Ctrl-Shift-Enter
=IF(G2="","",INDEX($A$1:$A$18,MAX(($B$2:$B$18=F2)*($C$2:$C$18<=G2)*($D$2:$D$18>=G2)*ROW($A$2:$A$18))))
Try this in H2:
Confirmed with Ctrl-Shift-Enter=IF(G2="","",INDEX($A$1:$A$18,MAX(($B$2:$B$18=F2)*($C$2:$C$18<=G2)*($D$2:$D$18>=G2)*ROW($A$2:$A$18))))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks