Array entered
=IFERROR(INDEX(A$2:A$11,MATCH(0,IF(B$2:B$11>0,"",COUNTIF(E$1:$E1,A$2:A$11)),)),"")
Array entered
=IFERROR(INDEX(A$2:A$11,MATCH(0,IF(B$2:B$11>0,"",COUNTIF(E$1:$E1,A$2:A$11)),)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks