How to write function to get distinct values from column

[skumarlingam]

Hi All,

I am new to excel, currently am using MS Excel 2007 for my project.

I have a roadbloack i need to retrieve distinct values from available list of values(text).

scenerio :

I have data from M4 : M71 --> few are repeated.

I want to apply formula on it to get only unique values from list.

if anybody help me out how to write function.

Thanks in advance,

sk

[ChemistB]

With Excel 2007, on the Data Tab of the ribbon is Remove Duplicates. This removes them in place.

If you want a unique list elsewhere without the duplicates while keeping the original list intact, use the advanced filter (same tab) and check off "Copy to a new Location" and "Unique records only." Advanced filter requires your column have a header and you can only copy to the same spreadsheet. (From there you can cut and paste whereever you like).
Does that help?

[skumarlingam]

Thanks ChemistB for your reply.

I tried but no luck.