View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Sort unique data from a colum

Data Filter Advanced Filter then set up your conditions and check the
box "Unique records only" OK

Vaya con Dios,
Chuck, CABGx3





"TR Young" wrote in message
...
I have a column (let's call it 'Column C') of data that represents part
numbers required to build an assembly. In Column C are multiple part
numbers, some of which are repeated.

What I want to do is have Column D report all the unique data from Column
C, without repeating any of the part numbers.

Basically what I want to do is isolate the parts required. No amounts,
just the parts required.

Thanks in advance!