Forum Discussion
Validation of similar (but not identical) data
I have codes of the same product that resemble in just a few characters, for example: GV-A4-828645 and 5A4828645. Therefore they are not identical to the point of the function CONT.SE (B $ 3: B $ 11; B3) = 1 accuse duplicity and prevent typing more than once.
My question: Is there any function for Excel to identify and prevent any possible repetition of values based on the sequence of the last 6 typed characters (825645)? Can the formula CONT.SE (B $ 3: B $ 11; B3) = 1 be written for this purpose?
Thanks in advance to the community!
1 Reply
Hi,
If the possibility of repetition is always in the last 6 characters, it's possible as follows:
=SOMARPRODUTO(--(DIREITA($B$3:$B$11;6)=DIREITA(B3;6)))
Otherwise, the solution can be difficult!
