none
sequence of serial numbers RRS feed

  • Question

  • Dear,

    please help me regarding sequence number making formula or VBA code in excel.

    as like below example.but there are some numbers is jumped when the sequence was reached there.

    Range for jumped.  

    (10000400 to 10000415 / 10000700 to 10000715 / 10000800 to 10000815 / 10001300 to 10001315)

    23000100
    23000101
    23000102
    23000103
    23000104
    23000105
    23000106
    23000107
    23000108
    23000109
    23000110
    23000111
    23000112
    23000113
    23000114
    23000115
    23000200
    23000201
    23000202
    23000203
    23000204
    23000205
    23000206
    23000207
    23000208
    23000209
    23000210
    23000211
    23000212
    23000213
    23000214
    23000215
    23000300
    23000301
    23000302
    23000303
    23000304
    23000305
    23000306
    23000307
    23000308
    23000309
    23000310
    23000311
    23000312
    23000313
    23000314
    23000315
    23000500
    23000501
    23000502
    23000503
    23000504
    23000505
    23000506
    23000507
    23000508
    23000509
    23000510
    23000511
    23000512
    23000513
    23000514
    23000515
    23000600
    23000601
    23000602
    23000603
    23000604
    23000605
    23000606
    23000607
    23000608
    23000609
    23000610
    23000611
    23000612
    23000613
    23000614
    23000615
    23000900
    23000901
    23000902
    23000903
    23000904
    23000905
    23000906
    23000907
    23000908
    23000909
    23000910
    23000911
    23000912
    23000913
    23000914
    23000915
    23001000
    23001001
    23001002
    23001003
    23001004
    23001005
    23001006
    23001007
    23001008
    23001009
    23001010
    23001011
    23001012
    23001013
    23001014
    23001015
    23001100
    23001101
    23001102
    23001103
    23001104
    23001105
    23001106
    23001107
    23001108
    23001109
    23001110
    23001111
    23001112
    23001113
    23001114
    23001115
    23001200
    23001201
    23001202
    23001203
    23001204
    23001205
    23001206
    23001207
    23001208
    23001209
    23001210
    23001211
    23001212
    23001213
    23001214
    23001215
    23001400
    23001401
    23001402
    23001403
    23001404
    23001405
    23001406
    23001407
    23001408
    23001409
    23001410
    23001411
    23001412
    23001413
    23001414
    23001415
    23001500
    23001501
    23001502
    23001503
    23001504
    23001505
    23001506
    23001507
    23001508
    23001509
    23001510
    23001511
    23001512
    23001513
    23001514
    23001515
    23010000
    23010001
    23010002
    23010003
    23010004
    23010005
    23010006
    23010007
    23010008
    23010009
    23010010
    23010011
    23010012
    23010013
    23010014
    23010015
    23010100
    23010101
    23010102
    23010103
    23010104
    23010105
    23010106
    23010107
    23010108
    23010109
    23010110
    23010111
    23010112
    23010113
    23010114
    23010115
    23010200
    23010201
    23010202
    23010203
    23010204
    23010205
    23010206
    23010207
    23010208
    23010209
    23010210
    23010211
    23010212
    23010213
    23010214
    23010215
    23010300
    23010301
    23010302
    23010303
    23010304
    23010305
    23010306
    23010307
    23010308
    23010309
    23010310
    23010311
    23010312
    23010313
    23010314
    23010315
    23010400
    23010401
    23010402
    23010403
    23010404
    23010405
    23010406
    23010407
    23010408
    23010409
    23010410
    23010411
    23010412
    23010413
    23010414
    23010415
    23010500
    23010501
    23010502
    23010503
    23010504
    23010505
    23010506
    23010507
    23010508
    23010509
    23010510
    23010511
    23010512
    23010513
    23010514
    23010515
    23010600
    23010601
    23010602
    23010603
    23010604
    23010605
    23010606
    23010607
    23010608
    23010609
    23010610
    23010611
    23010612
    23010613
    23010614
    23010615
    23010700
    23010701
    23010702
    23010703
    23010704
    23010705
    23010706
    23010707
    23010708
    23010709
    23010710
    23010711
    23010712
    23010713
    23010714
    23010715
    23010800
    23010801
    23010802
    23010803
    23010804
    23010805
    23010806
    23010807
    23010808
    23010809
    23010810
    23010811
    23010812
    23010813
    23010814
    23010815
    23010900
    23010901
    23010902
    23010903
    23010904
    23010905
    23010906
    23010907
    23010908
    23010909
    23010910
    23010911
    23010912
    23010913
    23010914
    23010915
    23011000
    23011001
    23011002
    23011003
    23011004
    23011005
    23011006
    23011007
    23011008
    23011009
    23011010
    23011011
    23011012
    23011013
    23011014
    23011015

    Regards,

    ABAS 

    Wednesday, January 11, 2017 7:22 PM

All replies

  • Hi Abas -

    You might want to restate your question so it's a little clearer. There are 2 scenarios I can see here and I don't know which you mean.

    (1) Do you want to take an input of
    (10000400 to 10000415 / 10000700 to 10000715 / 10000800 to 10000815 / 10001300 to 10001315)

    and have excel list the number sequence that the statement describes in rows? Or...

    (2) Do you want Excel to take that long list of numbers and summarize it so that:
    (10000400 to 10000415 / 10000700 to 10000715 / 10000800 to 10000815 / 10001300 to 10001315)

    is the output?


    -MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com

    Wednesday, January 11, 2017 7:41 PM
  • Dear sir,

    review my question up side you will find some values when the value reach to this figure (10000400 to 10000415 / 10000700 to 10000715 / 10000800 to 10000815 / 10001300 to 10001315) jumped the value to next serial because in our sequence we don't want to mentioned this four serials groups.

    Regards,

    ABAS

    Thursday, January 12, 2017 5:56 AM
  • ABAS -

    I still have no idea what is input & output. Please understand that I choose to post my reply to help you get an answer, not to re-read what was unclear before. Depending on your response, myself or someone else may choose to answer. Until then, there just is no way to know what you need!

    Either way, the answer to your question will be simple. Your list doesn't match the line at all. Every entry in your single line starts with a '100'. There isn't an entry starting with '100' to be found in that long line of stuff posted.


    -MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com


    • Edited by MainSleuth Thursday, January 12, 2017 2:05 PM
    Thursday, January 12, 2017 1:58 PM
  • Dear sir,

    my sequence start from ( 10000100  to  10000115).

    in this sequence the start three characters from left side ( 100 ) this serial for this sequence. and the after this more three characters ( 001 ) this step and last two characters ( 00 ) this pair.

    total sequence start from ( 10000100 to 10011015)

    Note: there my sequence reach to some step the value jumped to next step and miss that step which we want to forget.

    forget steps: (10000400 to 10000415 / 10000700 to 10000715 / 10000800 to 10000815 / 10001300 to 10001315)

     for this we need formula or VB code to make it easy.

    Regards,

    ABAS

    Thursday, January 12, 2017 3:40 PM
  • ABAS -

    I'm still clueless as to what your inputs and outputs are, so language is an issue. Let me take a guess with different numbers.

    Example:

    For an Input in Cell (C12) of:(34001 to 34004 / 34067 to 34070)

    You desire the Output starting in cell (C15) to be:
    34001
    34002
    34003
    34004
    34067
    34068
    34069
    34070


    -MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com

    Thursday, January 12, 2017 5:40 PM
  • Dear sir,

    if you will give me you email address i will send to you my sheet.

    Regards,

    ABAS

    Thursday, January 12, 2017 7:05 PM
  • No idea what you want,
    but this chart looks interesting to me.
    http://www.mediafire.com/file/8rs2w89qnnn7634/01_12_17a.pdf

    Thursday, January 12, 2017 10:35 PM