Hi
The below formula is looking through a big list of names, all name populate more than once, the formula pulls out a list of the names only once so I can see a shorter list of how many names a represented in the big list.
The problem is there is also blanks in this list of names and this formula is considering a Blank a name, the blank cell it counts does have a formula in it.
=IFERROR(INDEX(Reference!$G$2:$G$600,MATCH(0,COUNTIF(H$2:$H2,Reference!$G$2:$G$600)+IF(COUNTIF(Reference!$G$2:$G$600,Reference!$G$2:$G$600)>1,0,1),0)),"")
The part I have underlined I believe to be the problem but I cant work it out.
Assistance would be appreciated.
Its an Array formula.
Thanks
Bookmarks