Here you go. Advanced Filter, Check Copy to Another Location,Unique Records Only Copy to: Select the cell where you want to paste. Click OK. U are done.