hello i need some help to count characters within a string, if there is any repeated number, return "paired" or something. if anyone can help I would appreciate it, follow the example
see:
=ARRAYFORMULA(IF(F5:F="",,
IF((MID(F5:F, 4, 1)=MID(F5:F, 1, 1))+
(MID(F5:F, 4, 1)=MID(F5:F, 7, 1)),
"1 - paired", "2 - not paired")))