Data filtering logic

[Neico]

Hello,

I'm trying to figure out a multi-step filtering logic for my data:

ID	Affected by	Type	Weight
1	A	inactive	0.6
1	B	active	0.4
2	C	inactive	1
3	A	inactive	0.4
3	B	active	0.2
3	D	active	0.4

I would like to keep rows under the following criteria:

• if they are unique --> keep row for ID 2
• if ID is a duplicate then keep if there's a single Type = "active"
• if ID is a duplicate and there are multiple Type = "active" then keep the one with the highest value under Weight

The resulting table should thus be:

ID	Affected by	Type	Weight
1	B	active	0.4
2	C	inactive	1
3	D	active	0.4

Thank you for your help!

[ImadZidan · Accepted solution]

Hello @Neico ,

Just an idea with just using tools.

Hope it helps.

[Neico]

So simple but effective. Thank you!