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;...
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!