Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeated Nos
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeated Nos
Hi
Use Advance Filter Select your range of dataDataFilterAdvanced FilterUnique values onlycopy to new locationclick on a cell e.g. C1Finish -- Regards Roger Govier "vlook fomula" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeated value | Excel Worksheet Functions | |||
maximum repeated value | Excel Worksheet Functions | |||
Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
Repeated row | Excel Discussion (Misc queries) | |||
repeated numbers | Excel Worksheet Functions |