Math help

[mathman04232423]

Help. I need a way to display all 8 digit numbers that have the digits 1-8 in them. (ie. 12345678 but NOT 12345679 OR 12345677) Also If I could somehow divide by 13 then check for whole numbers that would be great... thx

[sweep]

Hi,

Confirm the numerals from 1 through 8 using

=AND(FIND("1",A1),FIND("2",A1),FIND("3",A1),FIND("4",A1),FIND("5",A1),FIND("6",A1),FIND("7",A1),FIND("8",A1))

confirm that when divided by 13 a whole number is present with

=A1/13=INT(A1/13)

[shg]

Maybe
=IF(AND(LEN(A1)=8, ISERROR(FIND("9", A1)), MOD(A1, 13) = 0), A1, "")

64451166, for example, passes.

Mathman, please read our Forum Rules about thread titles before starting your next thread.

[olasa]

And Only 8 digit numbers?
=AND(ISNUMBER(FIND(ROW($A$1:$A$8);A1));LEN(A1)=8)
//Ola

Note: Array Entered (read the blue text)

[mathman04232423]

Hey thanks for the answers but I can't seem to get it to work. I don't want to make it seem like I'm not doing any work but could someone get me a list of numbers? Or even better the some of numbers?

[mathman04232423]

Ah... You don't understand, the digits can not repeat. Sorry about that

[shg]

=AND(ISNUMBER(FIND({"1","2","3","4","5","6","7","8"}, A1) ) )

Mathman, please acknowledge my request in post #3.