Compare 2 rows and insert a new column

[Soraju]

Hello! 

could someone please help me with the below scenario?

Scenario : I have a data set with duplicate SKU numbers in a column. I want to check the whole column and if the SKU shows up multiple times then I want a new column to say -Duplicate, else It should say Unique.

Example :

SKU	Description
1234	Toy
3456	Beverage
1234	Toy
8657	Paper
9058	Soda
3456	Beverage
7685	Wrap
9846	Flower

And I would like a new column to find out unique/duplicate:

SKU	Description	New column
1234	Toy	Duplicate
3456	Beverage	Duplicate
1234	Toy	Duplicate
8657	Paper	Unique
9058	Soda	Unique
3456	Beverage	Duplicate
7685	Wrap	Unique
9846	Flower	Unique

[atcodedog05]

Hi @Soraju 

Here is one way of doing it.

Hope this helps : )

[Soraju]

Thank you for your prompt response. I will try that.