Sort unique data from a colum

T

TR Young

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

clr

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

Vaya con Dios,
Chuck, CABGx3
 
T

TR Young

Thank you, Chuck! Exactly what I needed.

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

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top