How many blocks in ascending order are possible in sequences of 2,3,4,5,6,7,8 Ex = blocks of 2 = 01 02 02 03 ............ 24 25
Blocks of 3 = 01 02 03 02 03 04 ......... 23,24,25
....
Blococ of 7 = 01 02 03 04 05 06 07, 02,03 04 05 06 07 08 .......... 16 17 18 19 20 21 22 ..
There will be blocks of 2,3 4,5,6,7,8
Increasing order without intervals in blocks
A1 is the max value in the sequence.
=SUM(A1-{1,2,3,4,5,6,7})
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Okay. You can put an attachment in a spreadsheet! please
NO!!!! You must provide a sample sheet. It is NOT for those helping you to do this.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hello please!!!
Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
From the forum rules (link in the main menu above):
- If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
I have no idea what your sheet is suppose to represent or what additional information you're asking for. The formula I gave you counts the the number of "sequences" that you described. What else do you want?
Okay, but the question has not been resolved.
* The formula is not working, I need
ok!!! thank you!
You are still ignoring the request for links. Post them now, please.
create all sequences of increasing order of 2,3,4,5,6,7 from 01 to 25.
I do not understand which link?
* I need to solve the training issue, just this!
If I understand correctly try the following:
1) put the number of elements (25) in cell A1,
2) put the block size (2,3,4...) in cell A2,
3) the number of blocks can be calculated using the following formula: =A1-A2+1
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hello, jeteMc, yes you are correct! Can you get on a plane please?
careful, google translates very poorly!
* is to put in an attachment for me to download
I feel like post #15 was pretty specific as to how to set up a spreadsheet, however here is the attachment as requested.
Let us know if you have any questions.
But this is the formations of 2,3,4,5,6,7
* Ex =
01 02
02 03
03 04
(I.e.
...
24 25
* And the other
Of 5
01 02 03 04 05
02 03 04 05 06
03 04 05 06 07
......
21 22 23 24 25
And the other formations 3,4,6,7, ??
Ok, I think that I understand.
After filling the first cell with the number 1 the following formulas are used:
1) For the rest of the first column: =IF(B5<A$3,B5+1,"")
2) For the remainder of each row: =IFERROR(IF($A$2>COUNT($B5:B5),B5+1,""),"")
Let us know if you have any questions.
Ok almost there
* Has split into groups
* 2 out of 3 in 4 on 5 on 6 on 7
An example of the group of 6
01 02 03 04 05 06
02 03 04 05 06 07
03 04 ....
Ok ok this correct, JETEMC perfect, very good job! thank you
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks