+ Reply to Thread
Results 1 to 4 of 4

I want to make a custom series that produce with respect to a variable number

  1. #1
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    I want to make a custom series that produce with respect to a variable number

    Hi,

    Please let me explain my issue.

    On excel sheet1 in cell BY7, i want to put a number say 35. Now i want that below it following pattern of numbering series should be filled
    7 to 31 ( 31-7=24 why 24 because 59-35=24 , Here 59 is always constant number and 35 is the variable number that i will change) then
    32 should not be written next, instead of this
    33 to 92 (gap of 59) then again
    93 should not be written next then
    94 to 153 (gap of 59) then again (and so on this way)

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: I want to make a custom series that produce with respect to a variable number

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: I want to make a custom series that produce with respect to a variable number

    Hi,

    I have attached the file.

    Please note that Cell BY6 is series generator. i will put any number in this. and according to my requirement a series should be generated.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: I want to make a custom series that produce with respect to a variable number

    In words:
    33 to 92 (gap of 59) then again
    In file: 33,34,2,3,...

    Which is correct ?
    Quang PT

+ 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. Fill custom series of numbers with respect to a specific variable number
    By Ahmad3453453 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2022, 07:42 PM
  2. Fill custom series of numbers with respect to a specific variable number
    By Ahmad3453453 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2022, 01:24 PM
  3. Plot Using Setsourcedata Method with Multiple but Variable Number of Series
    By lp3eb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2014, 12:46 PM
  4. Changing print area with respect to variable
    By soxcrates in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2012, 12:35 PM
  5. Replies: 4
    Last Post: 02-18-2012, 11:47 AM
  6. Custom format cells - how to make it say < number
    By liniis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2006, 07:30 PM
  7. make:Custom Number Format
    By robertjtucker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2006, 02:35 PM

Tags for this Thread

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