LinkBack URL
About LinkBacks
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
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
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)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
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.
Last edited by shg; 07-16-2008 at 11:29 AM.
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)
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?
Ah... You don't understand, the digits can not repeat. Sorry about that
=AND(ISNUMBER(FIND({"1","2","3","4","5","6","7","8"}, A1) ) )
Mathman, please acknowledge my request in post #3.
Ok I read the rules. I don't know how to change the title of my thread. I will if I figure it out.
Also, Can someone tell me how to make it add up all the 'TRUES'
Last edited by mathman04232423; 07-16-2008 at 02:32 PM.
You can't change it now. I'm looking for a lucid and concise title in your next thread.
I managed to get a list of numbers. There are like 7 million numbers on the list and 3111 say 'True'. Is there any way I could make it add all the True's together, or just put them close together so that they arent all 6000 rows apart?
Here's some.
Last edited by shg; 07-17-2008 at 12:21 AM.
Thanks so much, now I only have 393 to go... any tips on extracting TRUES out of a pile of #VALUE! ???
Sort.
Or you can take the 5040 I posted and do a cyclic permutation to get the balance of 40,320. List those in the first column, and in B1 and across and down,
=VALUE(SUBSTITUTE( A1 + 11111111, "9", "1") )
E.g,
Please Login or Register to view this content.
Thanks for the help everybody. I got the answer. Can a moderator please delete this thread?
We don't delete completed threads.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks