Hi all,

I have a dynamic list which contains dupes and am trying to create a second list with unique entries..

My situation:

I have a long list of companies on sheet1 A2:A800 (with duplicates)

I need the refined list of companies on sheet2, starting from A2

However, the list on sheet 1 is a dynamic worksheet that updates info from our CRM system, however the companies will always be in column A... There will be blanks so i guess if anyone knows how to also get a formula to incorporate ignoring those.

I have tried...
=IFERROR(INDEX(Table1[Introducer Company],MATCH(0,COUNTIF(A$2:A2,Table1[Introducer Company]),0)),"")

then dragging it down, but that just gives me a list of zeros with circular referencing.

I am using Excel 2010 if that makes a difference

Any help!?