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

Question

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

twifoo · Answer

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

Forum Discussion

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

1 Reply

Resources