| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort unique data from a colum
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sort unique data from a colum
Thank you, Chuck! Exactly what I needed.
"clr" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding two colum cells only if there is data in 3rd colum | Excel Worksheet Functions | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Hybrid Mode
