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