Help with Tolerance formula

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.

=IF(MAX(COUNTIF(E:E,E:E))>1,"DUPE","No Dupe")

Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Finance AnalystCommented:
In a neighbouring column add formula that will round each of the values to the tolerance value:

=MROUND(A2,0.05)

For your example, 502.81 will round to 502.80 or 502.83 will round to 502.85

Thanks
Rob H
Commented:
Like this
=IF(COUNTIFS(E:E,">="&E2-0.05,E:E,"<="&E2+0.05)>1,"DUPE","No Dupe")

Experts Exchange Solution brought to you by