Repeated Nos

  • Thread starter Thread starter vlook fomula
  • Start date Start date
V

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
 
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

vlook fomula said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top