how to make a unique record of a column in excel ( not using advanced filter, but using formula/function..?

Answer 1

Name the column,Highlight the column,goto insert,name ,create.This will create a unique record,this way if so wanted can easily make a list or reference to that specific name in other functions.