none
serial number in sequence with rangeserial number in sequence with range

    Question

  • Dear community members,

    please help me regarding below my issue.

    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

    Monday, January 16, 2017 7:14 PM

Answers

All replies