Home

extract duplicate cell values from a column and copy to new column

%3CLINGO-SUB%20id%3D%22lingo-sub-727179%22%20slang%3D%22en-US%22%3Eextract%20duplicate%20cell%20values%20from%20a%20column%20and%20copy%20to%20new%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727179%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20extensive%20column%20with%20many%20of%20the%20same%20values%20listed.%26nbsp%3B%20%26nbsp%3BI%20need%20a%20formula%20that%20will%20identify%20each%20unique%20value%20then%20copy%20it%20once%20into%20a%20whole%20new%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-727179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20formulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-727263%22%20slang%3D%22en-US%22%3ERe%3A%20extract%20duplicate%20cell%20values%20from%20a%20column%20and%20copy%20to%20new%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727263%22%20slang%3D%22en-US%22%3ETo%20extract%20a%20sorted%20distinct%20list%2C%20you%20may%20construct%20your%20formula%20similar%20to%20that%20which%20I%20posted%20as%20the%20last%20comment%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Fexcel-extract-a-unique-list%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myonlinetraininghub.com%2Fexcel-extract-a-unique-list%3C%2FA%3E%3C%2FLINGO-BODY%3E
petergerard
Occasional Visitor

I have an extensive column with many of the same values listed.   I need a formula that will identify each unique value then copy it once into a whole new column.

1 Reply
To extract a sorted distinct list, you may construct your formula similar to that which I posted as the last comment here:
https://www.myonlinetraininghub.com/excel-extract-a-unique-list
Related Conversations