LinkBack URL
About LinkBacks
Perhaps this array formula filled across the sheet for 10 columns...
Change the ">=" to ">" if you really want to reject an exact match.
D$6&", "&INDEX($B$7:$B$15,MATCH(MIN(IF(D$7:D$15>=$C$20,D$7:D$15,"")),D$7:D$15,0))
Beau Nydal
Perhaps this array formula filled across the sheet for 10 columns...
Change the ">=" to ">" if you really want to reject an exact match.D$6&", "&INDEX($B$7:$B$15,MATCH(MIN(IF(D$7:D$15>=$C$20,D$7:D$15,"")),D$7:D$15,0))
Beau Nydal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks