Answer for "Find out if a number has repetitive digits" Formula Home work

[Kutty]

is this correct or not...

IF(IFERROR(FIND(9,A1)<FIND(9,A1,FIND(9,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(8,A1)<FIND(8,A1,FIND(8,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(7,A1)<FIND(7,A1,FIND(7,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(6,A1)<FIND(6,A1,FIND(6,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(5,A1)<FIND(5,A1,FIND(5,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(4,A1)<FIND(4,A1,FIND(4,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(3,A1)<FIND(3,A1,FIND(3,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(2,A1)<FIND(2,A1,FIND(2,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(1,A1)<FIND(1,A1,FIND(1,A1)+1),FALSE)=TRUE,TRUE,IF(IFERROR(FIND(0,A1)<FIND(0,A1,FIND(0,A1)+1),FALSE)=TRUE,TRUE,FALSE))))))))))

please tell me.

 

[Kutty]

I think it will help you to understand clearly

 

[NARAYANK991]

Hi ,

A shorter formula , an array formula , would be :

=MAX(FREQUENCY(MATCH(0+MID(A1, ROW(INDIRECT("1:" & LEN(A1))),1),{0,1,2,3,4,5,6,7,8,9},0), {0,1,2,3,4,5,6,7,8,9})) > 1

This is to be entered using CTRL SHIFT ENTER.

A non-array formula would be :

=ISNUMBER(MODE.MULT(MATCH(0+MID(A1, ROW(INDIRECT("1:" & LEN(A1))),1),{0,1,2,3,4,5,6,7,8,9},0)))

Narayan

 

[shrivallabha]

If you copy the MATCH formula block Narayan has demonstrated on the bins_array part of FREQUENCY then the formula will extend capacity to check any duplicate like below (CTRL+SHIFT+ENTER)

=SUM((FREQUENCY(MATCH(MID(A1,ROW($A$1:INDEX(A:A,LEN(A1))),1),MID(A1,ROW($A$1:INDEX(A:A,LEN(A1))),1),0),MATCH(MID(A1,ROW($A$1:INDEX(A:A,LEN(A1))),1),MID(A1,ROW($A$1:INDEX(A:A,LEN(A1))),1),0))>1)+0)>0

 

[AliGW]

Is it usual here to do people's homework for them???

 

[Kutty]

This post is a response to the previously asked question. But mine is without array formula.
https://chandoo.org/wp/2017/10/03/number-has-repetitive-digits-formula/

 

[Kutty]

I'm surprised to see everybody posting their formula in different view. Thanks to Excel Ninjas.

 

[John Jairo V]

Hi, to all!

Another options could be (without CSE):
=LEN(A1)>COUNT(INDEX(FIND(ROW(1:10)-1,A1),))
=LEN(A1)>COUNT(FIND({0,1,2,3,4}+{0;5},A1)) <-- Lori's formula.

Blessings!