Originally Posted by Jacc Is this correct? Formula: =INDEX(K:K,MIN(IF($K$2:$K$38>=C2,IF($L$2:$L$38=1,ROW($L$2:$L$38))))) Perfect.working. Thanks and rep.
=INDEX(K:K,MIN(IF($K$2:$K$38>=C2,IF($L$2:$L$38=1,ROW($L$2:$L$38)))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Bookmarks