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

Copper Contributor

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