removing dupes from the datasheet

[Sshasnk]

We have a dataset where we have three friends SLC, Kim, Tom, and Hanks. And out of these four SLC has the responsibility to get fruits. But in case if any of the other friends get the fruits then we have to remove them from 

Prd_Id	Name	Type	Price
123	SLC	Fruit	125.01
345	Kim	Vegetables	1457.00
123	Tom	Fruit	145.01
123	Hanks	Fruit	4527
456	SLC	Fruit	124.01
890	SLC	Fruit	126.01
159	Tom	Fruit	457.01
890	Kim	Fruit	523

Condition:

1. I have to check if the same product id and type is part of the sheet-> if they do I have to remove them

2. I duplicate was found then we have to select the record which has SLC

Example:

Product id -> 123 - SLC- fruit is also present for tom and hank so I have to remove them

another example: product id -> 159 - Tom - Fruit -> As SLCdoes have the same product id and type in the sheet so we have to include this

Output:

Prd_Id	Name	Type	price
123	SLC	Fruit	125.01
345	Kim	Vegetables	1457.00
456	SLC	Fruit	124.01
890	SLC	Fruit	126.01
159	Tom	Fruit	457.01

Let me know if any confusion 

[Emil_Kos]

Hi @Sshasnk,

I have created an order formula to make sure that I have sorted the data in the correct way:

The truth is I know that unique tool is rearranging the data but after some tests, it looks like it is working correctly

[Qiu]

@Sshasnk 

Maybe we need a big dataset for validate.