LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash

Hi, !


i would like to find if in 5 digits 1 digit is the sum of 2 digits, (or) the Sum of 3 Digits

it's might a lil complex, i've tried to doit but the problem is that the string is inside of single cell
and it's contain a dash.. ( i'm not excel guru yet)

Let say in G:12 I got a combination of 5 numbers (separated with dash)

then i wan to find if in combination a number have a sum of 2 digit or 3 digits, and if Found
then i would like to identify as :
-.If No Digit Sum any other digit, then "0D"
-.If 1 Digit is the Sum of 2 other Digit, then "2D"
-.If 1 Digit is the Sum of 3 other Digit, then "3D"

then the result ("OD","2D,"3D") will Add dd in Cell/Column AB:12 down


example:
______________________RESULT
____________COL G______COL AB__
R:12___01-02-05-33-35____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:13___01-02-06-15-33____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:14___02-05-08-17-20____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:15___05-06-14-15-23____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:16___01-02-05-33-35____ "2D", <--because, Digit Sum 02+33 is equal to Digit 35
R:17___01-02-06-08-32____ "2D", <--because, Digit Sum 02+06 is equal to Digit 08
R:18___02-05-07-08-20____ "2D", <--because, Digit Sum 02+05 is equal to Digit 07
R:19___05-06-14-19-29____ "2D", <--because, Digit Sum 05+14 is equal to Digit 19
R:20___01-02-05-08-19____ "3D", <--because, Digit Sum 01+02+05 is equal to Digit 08
R:21___01-02-05-14-20____ "3D", <--because, Digit Sum 01+05+14 is equal to Digit 20
R:22___01-02-06-19-26____ "3D", <--because, Digit Sum 01+06+19 is equal to Digit 26
R:23___02-05-08-28-35____ "3D", <--because, Digit Sum 02+05+28 is equal to Digit 35




Thank you for your help !!



Best Regards

David

Hi Darthvader68,


-.Yes,Indeed you're right about first Cell AB, 02+33 = 35 (Sorry, I skipped),

-. About the Messages :
<--because, no X or Y digit make a Sum of X Digit
<--because, Digit Sum XX+YY is equal to Digit XX
<--because, Digit Sum XX+YY+ZZ is equal to Digit XX

I wrote it for explanation purposes, (Sorry again, i didn't to make you work double.. )

Question : what function name do i have to insert in cell AB12 in order to get the "0D","2d" or "3D"?,
because in Cell AB12 I inserted

Please Login or Register  to view this content.

and sadly didn't work, it pop a excel error message that
say is not begin with letter or underscore,the name contain space or other invalid character, the name conflict with an excel built-in name..

So in the code i changed the name to : LotCheckSum, and inserted this name in AB12 and receive same error message..


please if have a question, pls let me know..


Appreciated a lot mr Darthvader68..

Best Regards

David

Hi DarthVader68 ,

Yes i noticed after the post #3.. I apologized, time to time i'm lil dummy (smile)

Thank you so much, it work perfect !!!!!!!!!!!!

Best Regards

David