+ Reply to Thread
Results 1 to 4 of 4

Listing Range of Numbers, Given "Starting Number + x"

  1. 02-11-2023, 08:52 AM #1
    your
    your is offline
    Registered User
    Join Date
    01-28-2021
    Location
    Kedah
    MS-Off Ver
    2016
    Posts
    22

    Listing Range of Numbers, Given "Starting Number + x"

    Hi,

    Search on Google for a week but could not find any solution.
    The sample of data in attachment.

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-11-2023, 09:14 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Listing Range of Numbers, Given "Starting Number + x"

    In AA2

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Copy across and down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 02-11-2023, 10:32 AM #3
    your
    your is offline
    Registered User
    Join Date
    01-28-2021
    Location
    Kedah
    MS-Off Ver
    2016
    Posts
    22

    Re: Listing Range of Numbers, Given "Starting Number + x"

    Thanks, you are a genius.

    I thought formula/function could not solve the problem.
    Last edited by your; 02-11-2023 at 10:39 AM.
    Reply With QuoteRegister To Reply
  4. 02-18-2023, 08:27 AM #4
    your
    your is offline
    Registered User
    Join Date
    01-28-2021
    Location
    Kedah
    MS-Off Ver
    2016
    Posts
    22

    Re: Listing Range of Numbers, Given "Starting Number + x"

    Is there a way to modify the formula so the result in column
    I tried change "COLUMNS" to "ROWS" but did not work

    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    a & b column - vertical.xlsb
    Expected results are in Column T & X
    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)

Similar Threads

  1. [SOLVED] Sum from starting cell "x" number of cells across
    By lisaad in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2022, 10:57 PM
  2. Find MAX value from a range of time intervals displayed as "days", "hrs", "mins"
    By Liam5 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-05-2020, 02:08 AM
  3. Can't create "Secondary Dependent" DropLists listing "Unused" options
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2019, 05:17 PM
  4. Formula help - search multiple columns for text "starting with" names in a named range
    By lcgeek in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 03:00 PM
  5. I need to copy a range of cells starting from a header row to "sheet2"
    By goldbeje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 05:32 PM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. Copying an unknown number of cells in Sheet1 to Sheet2 starting from "F2"
    By blurtoad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2007, 07:27 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1