remove duplicate with condition

[SAMUT Fabrice]

Hello,

I used your expression :If(Rank(Rowid(),"asc",[Col_1],[Col_2],[Col_N])=1,"1st Record","Duplicate Record") to identify duplicate rows.

But now, I wonder if it's possible to add condition on duplicate rows to limit them.

Example on the attached picture:

the VIN numebrUU1K6720X61961350 is duplicate twice and I want to add 2 conditions to decide if I remove it or keep it

condition 1 &2 : milege between Duplicate Record and 1st Record > 50km & clip_date difference between 1st Record andDuplicate Record > 10 days

Thank you for your help

Sincersly