Remove duplicates based on multiple criteria

You're getting really close now.

Only error is 3331. It needs to be result: 4 instead of 13.

Reason is that 4 is closer to the tolerance than 13 is.

in this case what should happen and why

In this case i would like 8 to be the kept result.

Reason is that 8 is between the tolerance 5-10 and 3 is outside.

and is 1 closer to 5 than 11?

In this case i would like to keep the result: 11.

The tolerance is 5-10.

The distance from 1 to 5 is 4.

The distance from 11 to 10 is 1.

Therefore i would like 11 to be the kept result.

try

At first sight it seems like 99 and 100 both works.

Can you explain the difference?
I will validate it later today to be sure 🙂