Thread: Repeated Nos
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vlook fomula vlook fomula is offline
external usenet poster
 
Posts: 43
Default 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