Copying unique numbers from one column to the another

Question

I have a C column with the various 6-digit numbers "operator ID". Each operator is assigned to number of activities so their number will appear a couple of times in the C column. I need to extract the numbers of each operator into a separate column so I will know how many operators were involved in these activities. In the picture, I have 23 IDs but only 3 operators were involved.

What will be the formula to achieve this?

I was trying to use "Unique" but it gives me a copy of all the numbers.

Answer 1

If you have, for example 50 rows in your column with the numbers (let's suppose it's column "A"), you can select i.e. the first cell of a column next to your data and type:

=UNIQUE(A1:A50)

Now you will get the unique values you want, in this new column.