this formula:
=INDEX(List,MATCH(0,COUNTIF($K$3:K14,List),0))
IS WORKING PERFECT, doing everything I need.
only issue sometimes the output is "#N/A"
its not a big deal but for my user I want the cell to appear blank
; QUESTION: what do i tweak??
THANK YOU!
Bookmarks