excel - Pull names from column in sheet 1 and place in column on another sheet removing duplicates -

i'm looking formula if possible.

i have sheet within workbook called 'raw' , in column 'i' has series of agent names. want copy these names sheet named 'ytd' column b in process of remove duplicates appear in new unique list.

the formula working below when try amend need circular reference errors. appreciated.

=index(raw!$i3:$i10000,match(0,index(countif(raw!i:i,raw!i:raw!i),0,0),0)) 

for tasks this, recommend use available manual tools present in excel. copy , paste column would, , in new list, go data ribbon > remove duplicates.

automation should used when have consistently repeating tasks same form of input , output. of random things need in excel, relying on automation developed elsewhere can reduce actual speed @ performing these tasks.