excelformulaunique-values

Copying unique numbers from one column to the another

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.

enter image description here

What will be the formula to achieve this?

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

Solution

  • 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.