Order. Macro to add by file line in excel
Example I intend to have sum 10
the macro sum per line in the value of 10
423111 =?
123411 =
432211 =
122234 =
Order. Macro to add by file line in excel
Example I intend to have sum 10
the macro sum per line in the value of 10
423111 =?
123411 =
432211 =
122234 =
Sorry jorel, I don''t understand what the macro should do?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Maybe:
Data Range
A B C D E F G H I J K L M 1 5 6 7 8 9 10 11 12 13 14 15 16 2 11234 111234 1111234 11111234 1.11E+08 1.11E+09 1.11E+10 1.11E+11 1.11E+12 1.11E+13 1.11E+14 1.11E+15 1.11E+16
Formula:Please Login or Register to view this content.
Last edited by xladept; 10-06-2017 at 02:07 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hello, aladept, perfect, good job Can you put it inside the worksheet for download?
I only did the one line but here:
This is not it, I need to add the formations then I will filter the ones of sum 10
I don't understand
Just add up, you have to separate the three lists 5,6,7 digits
And add
Example =
123341 = 16
111421 = 10
111321 = 9
111224 =?
This??
Okay XLAPEPT yes, yes, perfect, good job, but it does not have as much training in either 5,6,7
In the sum of 10? Strange is all higher than 10.
What I need in the three training lists up to 10
Can you ride the three lists of 5,6,7
Whose sum will always be 10, please
Yes this is the work, but the formations must be within the sum of 10
Maybe tomorrow - you want 5,6,7,8,9 digits that add up to 10??
hello ,yes, yes, that's correct! that's right! can do by doing, you repeat 3.4.5 times a digits
example 111115 = 10 or
1,1,1,1,2,2,2 = 10
hello ,xladept, please, sum 10
I think someone has already done this - I'll put it before the Forum
Not in this post, do you have the link?
Water Cooler "Call in the Cavalry".
hello, xladept
https://www.excelforum.com/attachmen...1&d=1507634142
Like xladept, I'm unclear on what your end result should look like, but hopefully my efforts prove helpful. Using your attachment from post #18, I inserted a blank column for column AP. I then used the following formula in cell Q5:
=IF(ISNUMBER(MATCH(Q$4,$A5:$O5,0)),"x","Y")
This formula replaces your yellow cells with the letter "Y", which is easier to work with than a color. This formula can be filled right through column AO and down through row 1564. With the "Y" values in place, you can then use the formula below in AQ5. This formula must be array entered (Confirmed with Ctrl + Shift + Enter instead of Enter):
=IFERROR(1+SMALL(IF(($Q5:$AO5="Y")*(($R5:$AP5="x")+($R5:$AP5="")),COLUMN($Q5:$AO5)),COLUMN(A:A))-SMALL(IF(($Q5:$AO5="Y")*(($P5:$AN5="x")+($P5:$AN5="")),COLUMN($Q5:$AO5)),COLUMN(A:A)),"")
Fill the formula right through BA5 and down through row 1564. The result should return your sequences of consecutive "Y" values. The formulas should automatically update as you change or refresh the data in columns A:O.
No macros are used.
Is this what you're looking for? Is it close? Take a look at the attachment to see if it helps:
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Hello, huuu! Perfect conglatulations very good job,
Now you just need to put in a highlighted color
Blue for x and yellow = y, and I'm still going to put it every week
New sweepstakes (refresh) the macro has to do automatic
When I'm going to start new raffles.
Very good job, thank you
I'm glad I could help! Coloring can be added with conditional formatting (See attached). When you change the numbers in A:O, everything else should adjust automatically. Hopefully that will be all that you need.
Good luck!
It took another field but try:
*ColoringPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by xladept; 10-10-2017 at 05:02 PM.
Hello, perfect cantosh and xladipt did a great job!
Congratulations, you got the best, fanstastic, thank you.
You're welcome and thanks for the rep!
ok thank you!!
Hello cantosh, you can add the number of digits
Example
1231211 = 7 dig. sum 10
121141 = 6 dig. Sum 10
In a list next to see the frequency of the digits
1 was drawn 500 times 2 = was drawn so many times 3 =? ....
Up to 6 =
Number of times that each type of training is drawn
In the position we have 9 vertical positions
1ª2ª3ª4ª5ª6ª7ª8ª 9ª
1 2 3 1 2 1 1 = we have 7 positions
1 2 1 ....
....... digit 1 in the first position has twice
You can you COUNTIF for all of your statistics. For the number of digits in each entry, use the following in BD5, filled down:
=COUNTIF(AQ5:BA5,">0")
For the number of occurrences of each number per position, create a 10 x 10 matrix and use the following formula in the top left corner of the matrix (BG5 in the attachment):
=COUNTIF(AQ$5:AQ$1564,$BF5)
Hopefully that gets you what you need?
Hello CAntosh, huu! Perfect, magnifico, the best !!!!
Much work! thank you
My pleasure, good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks