How to vlookup for a single column to find duplicate values

[JayeshG]

Hi,

I got around 6000 IDs in a column, most of them are duplicate in that. I want to get only unique values in that column to be displayed in second column. Can anyone help, will be great.

Thanks

[Pepe Le Mokko]

If you need distinct values, you can use the "remove duplicates" tool in the Data ribbon

[AlKey]

Use Advanced Filter

If you using Excel 2007-2013: Click on column A, go to Data, Advanced Filter, select Copy to another location and Unique Values only, in Copy to click on cell where you want your extracted data to be and click OK