+ Reply to Thread
Results 1 to 2 of 2

Count up to a number, then back down to 1, then back up

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    Canada
    MS-Off Ver
    MS Office 2013 Professional
    Posts
    18

    Count up to a number, then back down to 1, then back up

    Is there some sort of formula I could put together to do this?

    Like for example, if I wanted a column to read
    1
    2
    3
    4
    4
    3
    2
    1
    1
    2
    3
    4

    Without putting in those numbers manually, how could I do that?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Count up to a number, then back down to 1, then back up

    Put this in your starting cell (doesn't have to be A1 - it can be anywhere):

    =IF(MOD(INT((ROWS($1:1)-1)/4),2)=0,MOD(ROWS($1:1)-1,4)+1,4-MOD(ROWS($1:1)-1,4))

    and then copy down.

    Hope this helps.

    Pete

+ 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. [SOLVED] How to refer to back-to-back rows in code
    By JaydenK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2013, 03:58 PM
  2. [SOLVED] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  3. [SOLVED] Counting Number of Times a Value is Repeated REPEATEDLY (Back to Back)
    By patrickfshield in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-06-2012, 04:45 AM
  4. making stem and leaf back to back diagram
    By masxomas in forum Excel General
    Replies: 2
    Last Post: 05-05-2012, 02:38 PM
  5. Replies: 0
    Last Post: 10-01-2010, 08:16 AM

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