Forum Discussion
Finding duplicates using a margin of error
Hi everyone! I am trying to add a field validation to my excel spreadsheet that allows me not only to identify duplicate values that are identical (which I know how to do) but that will signal fi...
morgana9 Could you use a conditional formatting formula?
This formula would flag anything with a variance of 1 to a specified variable.
I'm thinking something like:
=AND(D1 <= $G$1+1,D1>=$G$1-1)
[where the variable is in G1, and the range of cells to validate against it is in column D]
macrordinary I'm not sure if that's exactly what I'm trying to achieve as it's not a specified value that I'd like to validate the range of cells against, but each other (signaling duplicates but with a little variability allowed)
but thanks anyways!