+ Reply to Thread
Results 1 to 4 of 4

using auto fill, but need to skip every 13th number

  1. 01-19-2006, 09:11 PM #1
    gotzoom
    gotzoom is offline
    Registered User
    Join Date
    01-19-2006
    Posts
    5

    using auto fill, but need to skip every 13th number

    I need to generate a sequential number list, but I need it to skip every 13th number.
    Reply With QuoteRegister To Reply
  2. 01-19-2006, 09:16 PM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    are you starting from 1?

    try putting 1 in A1 then in A2

    =A1+1+(MOD(A1+1,13)=0)

    and autofill down
    Reply With QuoteRegister To Reply
  3. 01-19-2006, 09:31 PM #3
    gotzoom
    gotzoom is offline
    Registered User
    Join Date
    01-19-2006
    Posts
    5
    I am starting at #2343. The above formula did not work as needed. Looks like it took out every number divisible by 13.
    Last edited by gotzoom; 01-19-2006 at 10:12 PM.
    Reply With QuoteRegister To Reply
  4. 01-19-2006, 10:35 PM #4
    gotzoom
    gotzoom is offline
    Registered User
    Join Date
    01-19-2006
    Posts
    5
    Ah-ha, I got it

    =A1+1+(MOD(A1-1,13)=0)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1