Try using Advanced filter.

Select all of the data including column header.
Select Data - Advanced Filter
Check Unique records box.
Please yourself whether you filter in place or copy to another location. If
you filter in place then the unwanted duplicate rows are hidden. If you copy
to a new location, the original list remains unchanged and the new list is
unique records only.

--
Regards,

OssieMac


"AMIT BHOPAL" wrote:

We have a material code list in one column.many code has repeat.

We want only one code come only one times.please help

Material code.
604789
604801
604801
604865
604865
604890
604893
604895
604895
604896
604896
604896
604901
604901
622992
622993



Submitted via EggHeadCafe - Software Developer Portal of Choice
USING TABLE TYPE TO ELIMINATE CURSORS
http://www.eggheadcafe.com/tutorials...-to-elimi.aspx
.