+ Reply to Thread
Results 1 to 16 of 16

Want to know about number generate method

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Want to know about number generate method

    Hi everyone,

    I want to know the method of below number generation. what will be next number series.

    753009
    753017
    753025
    753033
    753041
    753058
    753066
    753074
    753082
    753090
    753108
    753116
    753124
    753132
    753140
    ......
    ......
    ......
    ......

    Please help me.


    Thanks in advance.

    Tuhin

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Want to know about number generate method

    Key 753009 in A1
    Key 753017 in A2
    Select A1:A2
    Place cursor at fill handle (bottom right of A2) , cursor will change to black plus sign +
    drag down

    or

    Key 753009 in A1
    Ribbon Home > Fill > Series
    Check Column
    Step value 8
    Stop value 76000
    Ok

    or formula at A2
    =A$1+8*rows(A$2:A2)
    Last edited by Bo_Ry; 07-16-2020 at 02:10 PM. Reason: Forgot to lock row

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Want to know about number generate method

    Most of your numbers seem to increase by 8, but at the 6th number the increase is 17, and at the 11th number it is 18.

    There is too little example data to establish exactly what should happen next, so please attach more.

    Hope this helps.

    Pete

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Want to know about number generate method

    Quote Originally Posted by Bo_Ry View Post
    Key 753009 in A1
    or formula at A2
    =A1+8*rows(A$2:A2)
    hm.
    =A$1+8*rows(A$2:A2)
    or
    =A1+8

  5. #5
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Re: Want to know about number generate method

    See the below more...

    753009
    753017
    753025
    753033
    753041
    753058
    753066
    753074
    753082
    753090
    753108
    753116
    753124
    753132
    753140
    753157
    753165
    753173
    753181
    753199
    753207
    753215
    753223
    753231
    753249
    753256
    753264
    753272
    753280
    753298
    753306
    753314
    753322
    753330
    753348
    753355
    753363
    753371
    753389
    753397
    753405
    753413
    753421
    753439

  6. #6
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Re: Want to know about number generate method

    Quote Originally Posted by Pete_UK View Post
    Most of your numbers seem to increase by 8, but at the 6th number the increase is 17, and at the 11th number it is 18.

    There is too little example data to establish exactly what should happen next, so please attach more.

    Hope this helps.

    Pete
    please see more..

    753009
    753017
    753025
    753033
    753041
    753058
    753066
    753074
    753082
    753090
    753108
    753116
    753124
    753132
    753140
    753157
    753165
    753173
    753181
    753199
    753207
    753215
    753223
    753231
    753249
    753256
    753264
    753272
    753280
    753298
    753306
    753314
    753322
    753330
    753348
    753355
    753363
    753371
    753389
    753397
    753405
    753413
    753421
    753439

  7. #7
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Want to know about number generate method

    A1 => 753009

    a2
    =a1+8+(mod(mod(rows(a$1:a1)-1,19),10)=4)*9+sumproduct(--(mod(rows(a$1:a1)-1,19)={9,18}))*10

  8. #8
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38
    Quote Originally Posted by BMV View Post
    hm.
    =A$1+8*rows(A$2:A2)
    or
    =A1+8
    Thanks for your reply. But for your kind information every time incremental value is not 8. Please see my post carefully.

  9. #9
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Want to know about number generate method

    I am seeing the same kind of pattern that Pete_UK mentioned. I don't know how much of this is a spreadsheet question and how much is just pattern detection. As a spreadsheet question, I just put something like =A2-A1 (assuming these values are entered into column A) and copied down and looked at those values. Differences are mostly 8 a few 7s sprinkled in, with a periodic 17 or 18 (mostly a 5 entry period, with the occasional 4 entry cycle). If I identify each unique cycle pattern, then I see an abacbdbeb kind of pattern in the first set and the second set seems to have the same pattern. I'm beginning to see patterns within patterns (wasn't that something often said in Frank Herbert's Dune novels?). Do you have any more information to go on? How much of this pattern detection do you need Excel to do automatically?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  10. #10
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38
    Quote Originally Posted by Bo_Ry View Post
    A1 => 753009

    a2
    =a1+8+(mod(mod(rows(a$1:a1)-1,19),10)=4)*9+sumproduct(--(mod(rows(a$1:a1)-1,19)={9,18}))*10
    Thanks for the quick reply. But little bit correction needs in your formula. Because I found error in result. Please see the following

    753009 TRUE 753009
    753017 TRUE 753017
    753025 TRUE 753025
    753033 TRUE 753033
    753041 TRUE 753041
    753058 TRUE 753058
    753066 TRUE 753066
    753074 TRUE 753074
    753082 TRUE 753082
    753090 TRUE 753090
    753108 TRUE 753108
    753116 TRUE 753116
    753124 TRUE 753124
    753132 TRUE 753132
    753140 TRUE 753140
    753157 TRUE 753157
    753165 TRUE 753165
    753173 TRUE 753173
    753181 TRUE 753181
    753199 TRUE 753199
    753207 TRUE 753207
    753215 TRUE 753215
    753223 TRUE 753223
    753231 TRUE 753231
    753248 FALSE 753249
    753256 TRUE 753256
    753264 TRUE 753264
    753272 TRUE 753272
    753280 TRUE 753280
    753298 TRUE 753298
    753306 TRUE 753306
    753314 TRUE 753314
    753322 TRUE 753322
    753330 TRUE 753330
    753347 FALSE 753348
    753355 TRUE 753355
    753363 TRUE 753363
    753371 TRUE 753371
    753389 TRUE 753389
    753397 TRUE 753397
    753405 TRUE 753405
    753413 TRUE 753413
    753421 TRUE 753421
    753438 FALSE 753439

  11. #11
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38
    Quote Originally Posted by MrShorty View Post
    I am seeing the same kind of pattern that Pete_UK mentioned. I don't know how much of this is a spreadsheet question and how much is just pattern detection. As a spreadsheet question, I just put something like =A2-A1 (assuming these values are entered into column A) and copied down and looked at those values. Differences are mostly 8 a few 7s sprinkled in, with a periodic 17 or 18 (mostly a 5 entry period, with the occasional 4 entry cycle). If I identify each unique cycle pattern, then I see an abacbdbeb kind of pattern in the first set and the second set seems to have the same pattern. I'm beginning to see patterns within patterns (wasn't that something often said in Frank Herbert's Dune novels?). Do you have any more information to go on? How much of this pattern detection do you need Excel to do automatically?
    Thanks for your interest. Basically I got this type of number series in excel. Now it is to much needed to increase this number series. I don't get any logic of number series. But I know this number series must have a pattern.

  12. #12
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Want to know about number generate method

    How about
    A2
    =A1+8+(MOD(MOD(ROWS(A$2:A2),19),5)=0)*10-(MOD(MOD(ROWS(A$2:A2),19),10)=5)*(INT((ROWS(A$2:A2)/19))=0)-(MOD(MOD(ROWS(A$2:A2),19),10)=6)*(INT((ROWS(A$2:A2)/19))=1)

  13. #13
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Want to know about number generate method

    @Mofasol. It's better to describe rules in stand of write list of values.

  14. #14
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Want to know about number generate method

    I think the following gives the desired result. In A1 (has to be in row-1 !!) and dragged down:
    753000 + 100*INT((ROW()-1)/10) + 10*MOD(ROW()-1, 10) + MOD(11-2*ROW()-INT((ROW()+4)/10), 10)
    Shorter than Bo Ry's solution? - That can't be
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu

  15. #15
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Want to know about number generate method

    @GeoffW283 Very nice
    I can't see this pattern.

    Shortern version of your formula.
    =753000+(ROW()-1)*10+MOD(1-ROW()*2-INT((ROW()+4)/10),10)

  16. #16
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Want to know about number generate method

    @Bo_Ry - OK, OK, I knew you would improve on my attempt

    Thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A Selectionm method will generate a new line AND preserve indentation location?
    By excelicus in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2020, 05:01 PM
  2. Feedback Appreciated: VBA Coding Method: Simple Number to Words using SLST Method
    By MohsenAlyafei in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2019, 05:42 AM
  3. [SOLVED] Code to generate registry stored number from specific number
    By d_striker in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 02-09-2018, 04:37 PM
  4. Replies: 8
    Last Post: 11-18-2013, 04:24 PM
  5. How to generate the standard normal random vaiables from LCG method
    By bruceday in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2012, 06:05 PM
  6. Returning the number of cells from one method to another method.
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-08-2010, 11:28 AM
  7. generate a random number and use if function to generate new data
    By Dogdoc1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2006, 10:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1