+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 18 of 18

SOLVED - Need help with a non-sequential number pattern

  1. #16
    Registered User
    Join Date
    10-11-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Need help with a non-sequential number pattern

    That list is definitely much closer. Thanks. But, the round numbers are not right. Look at the 800 row. That should be the number 800. The round numbers there should be 100, 200, 300, 400, 500, 600, 700, 800. The row of 1600 should be number 1600. Etc. The whole sequence gets weird around those round numbers.

    And it weirdly makes a leap at number 4795. Instead of going back to 4096, it goes up to 4796. It makes another weird leap in the "95" section of the next sequence, too. Haven't looked at anything past those. Actually, after a quick glance, it gets really weird at the "95" section of every sequence. For some reason, it seems to jump to the next 800 numbers for numbers ending in "95-00". How weird.

    But, this is workable. I will have to manually fill in some of the missing numbers. And re-sequence a few. Still, it shouldn't take too long.

    If anyone can give me one that is fully accurate with which to compare, that would be great for proofreading.

    Thanks!

    PS. Actually, my Excel program is filling in the series for me in those "90" endings where that chart gets weird. So, I am not having to do much extra formatting.

    Thanks so very much! Thank you, thank you, thank you!!!!

  2. #17
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Re: Need help with a non-sequential number pattern

    I think I copied it down wrong, see if it's correct now. I have checked and when reordered there are no duplicates and seem to increment correctly.

    Dave H
    Attached Files Attached Files
    - Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
    - Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post

  3. #18
    Registered User
    Join Date
    10-11-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: SOLVED - Need help with a non-sequential number pattern

    Perfect!

    Pete and Dave, I cannot thank you enough for this work. It has helped me out tremendously. Thank you so very much!

    Mindy

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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