Time for a quick formula finesse check. Let’s say you have a number in A1. What formula can you use to find out if it has duplicate digits.
For example, if A1 has 123405, then answer should be FALSE
and if A1 has 123455, then answer should be TRUE
Go ahead and post your answers (formulas, VBA or M script) in the comments section.