+ Reply to Thread
Results 1 to 2 of 2

I need to create a list from a given number by adding 11 or 4 to get the next number

  1. #1
    Registered User
    Join Date
    01-21-2016
    Location
    USA
    MS-Off Ver
    Excel
    Posts
    2

    Question I need to create a list from a given number by adding 11 or 4 to get the next number

    I need to give excel one 11 digit number sequence ex. 12345678901
    Then be able to drag down and create the next numbers in the thread, from a formula
    These are the guidelines I need.

    +11 to get the next number in the thread
    But +4 to get the next number in the thread if the previous eleven digit number ENDS in the number 6 (ex.12345678906)
    Next number would be (12345678910)
    Next number would be (12345678921)

    I can also give excel the first and last number of the thread (both eleven digit numbers). Those are the two I am provided with. I need to find the numbers in between.
    Again by, starting with the first eleven digit number and adding 11 to get the next number, or adding 4, if the previous eleven digit number ends in the number six.

    Thats it. Thanks. -FP
    Last edited by fpitt; 01-21-2016 at 12:09 PM.

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: I need to create a list from a given number by adding 11 or 4 to get the next number

    Here you go
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

+ 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. Writing formula with IF, <, >, and =0
    By joshfulcher in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-22-2014, 04:46 PM
  2. Writing formula using vba
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2011, 10:37 AM
  3. writing an AND formula in VBA
    By juniperjacobs in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-23-2011, 09:59 PM
  4. Excel 2007 : Help writing a formula
    By JULIE1983 in forum Excel General
    Replies: 1
    Last Post: 03-02-2010, 01:39 PM
  5. [SOLVED] Need help writing formula plz..
    By nparrott in forum Excel General
    Replies: 8
    Last Post: 02-10-2006, 01:30 PM
  6. Replies: 2
    Last Post: 01-03-2006, 05:42 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