Hi
I have a requirement to delete duplicates with some custom conditions. Consider the Element "occurrence" in below image for your reference, I need a formula to automate this boolean element. Conditions are as follows
1.First two elements with first data "11" has Second Data "0" and "1" , In such a case , we need to check the one with "0".
2. Next three elements have similar conditions , hence we need to check both elements with value "0".
3. Next three elements with "13" has all "0" s in Second Data , hence any two can be checked.
4. All the other elements have unique values for "First Data" and hence all these needs to be unchecked..
Assumptions
There is at most one element with a particular value of "First Data' having "second Data" as "1".

Any help will be appreciated
Thanks and Regards
Aakash Sachdeva