Results 1 to 16 of 16

Repeating Sequence of Numbers

Threaded View

  1. #6
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    273

    Re: Repeating Sequence of Numbers

    Fluff13, Brief, neat and great! Thank you.

    I composed some ugly formula as well:

    Formula: copy to clipboard
    =IF(AND((MOD(ROWS($A1:A1)-1,4)+1)>0,(MOD(ROWS($A1:A1)-1,4)+1)<3),1,2)


    JohnTopley, Rick Rothstein. Great as well! Thank you!
    Last edited by T.I.; 10-04-2021 at 03:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return the number sequence of repeating value
    By NAXIB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2019, 02:14 AM
  2. Repeating sequence, how?
    By pepijnkr in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 01-30-2017, 08:53 AM
  3. [SOLVED] Show lowest missing number in a sequence w/repeating numbers and blanks
    By jayclinton in forum Excel General
    Replies: 6
    Last Post: 03-15-2016, 02:35 PM
  4. [SOLVED] repeating sequence
    By abhijit2610 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-21-2016, 11:12 AM
  5. Repeating sequence
    By HakeemJones in forum Excel General
    Replies: 9
    Last Post: 11-13-2014, 12:51 PM
  6. Repeating a sequence
    By Slothook in forum Excel General
    Replies: 3
    Last Post: 10-28-2011, 04:05 PM
  7. Repeating a sequence of numbers down a column
    By Nexan in forum Excel General
    Replies: 2
    Last Post: 03-04-2005, 02:06 PM

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