Repeated Nos

[vlook fomula]

Hi,

I have a list of material code in which every material code reaped several
time
Now I need a list on another sheet in which every material code come only
one time
Is there any method, I can use formula for that
Example

Material code
1002
1002
1002
1002
1003
1003
1003

Result

Material code
1002
1003

Thanks
Zafar

 

[Roger Govier]

Hi

Use Advance Filter

Select your range of data>Data>Filter>Advanced Filter>Unique values
only>copy to new location>click on a cell e.g. C1>Finish

--
Regards
Roger Govier

Hi,

I have a list of material code in which every material code reaped several
time
Now I need a list on another sheet in which every material code come only
one time
Is there any method, I can use formula for that
Example

Material code
1002
1002
1002
1002
1003
1003
1003

Result

Material code
1002
1003

Thanks
Zafar


__________ Information from ESET Smart Security, version of virus
signature database 4510 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com