+ Reply to Thread
Results 1 to 3 of 3

Repeating a sequence of numbers down a column

  1. #1
    Nexan
    Guest

    Repeating a sequence of numbers down a column

    Is there any way to fill down a column with a repeating sequence of numbers?
    In other words, instead of 1, 2, 3, 4, 5, 6..., I want the column to fill
    down with 1, 2, 3, 1, 2, 3, 1, 2, 3...

  2. #2
    Peo Sjoblom
    Guest

    Re: Repeating a sequence of numbers down a column

    Put 1 , 2 3 in the first 3 cells, select them. right click and drag copy
    down,
    upon releasing the right mouse button you'll get an option of copy cells,
    select it

    --

    Regards,

    Peo Sjoblom


    "Nexan" <Nexan@discussions.microsoft.com> wrote in message
    news:68DD8734-82A4-4021-8525-47FB97AABAD3@microsoft.com...
    > Is there any way to fill down a column with a repeating sequence of

    numbers?
    > In other words, instead of 1, 2, 3, 4, 5, 6..., I want the column to fill
    > down with 1, 2, 3, 1, 2, 3, 1, 2, 3...




  3. #3
    Ron Swinehart
    Guest

    RE: Repeating a sequence of numbers down a column

    Enter 1 at the top (A1 or whatever)
    In A2, enter =MOD(A1,3)+1
    Copy A2

    "Nexan" wrote:

    > Is there any way to fill down a column with a repeating sequence of numbers?
    > In other words, instead of 1, 2, 3, 4, 5, 6..., I want the column to fill
    > down with 1, 2, 3, 1, 2, 3, 1, 2, 3...


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1