Forum Discussion
Solved
Remove duplicates based on multiple criteria
Hi I have a pretty complicated task that i'm not able to crack myself. So i hope you guys can help me out? I have a dataset consisting of batch, results, lower tolerance and upper tolerance. The b...
and try this
Thanks a lot!
You just solved my problem. Appreciate it 🙂
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.
Ahmedx
Super User
Super Userand is 1 closer to 5 than 11?
- Ahmedx
and try this
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.
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 🙂Thanks a lot!
You just solved my problem. Appreciate it 🙂