I need to check a column and see if there are any duplicates but with a tolerance of 0.05
so 502.80 and 502.81 needs to show as a Duplicate
I am only looking to see if there are 2 amount the same in the column so for every amount in the column is there another with the same amount.
I have this formula but it does not have a tolerance and I can't figure out how to add a tolerance.
Thanks in advance