How to Extract Unique Values from a Column in Excel

preview_player
Показать описание
How to extract unique or distinct values from a column in Microsoft Excel

Begin by highlighting the required data set and selecting the data tab on the taskbar. From here find an option called 'remove duplicates' and press ok when prompted to. This will shrink the highlighted data set to filter out only unique values from any duplicates in the column.

Music by Adrian von Ziegler
Рекомендации по теме
Комментарии
Автор

Helped instantly it was real fast, thanks.

kxzjbni
Автор

the number is not unique it is a duplicate. Why didn't it isolate that number?

deldube
Автор

Sorry I meant the number 3 shows up 2 times why did it mark it as unique?

deldube