+ Reply to Thread
Results 1 to 5 of 5

Extracting range of numbers up to maximum that is in a cell

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Extracting range of numbers up to maximum that is in a cell

    I have days in Col A and max days in cell G1

    I would like a macro to extract from 1 in A2 up to the maximum in that is Cell G1 in Col A2 onwards


    I have attached a sample file


    It would be appreciated if someone could assist me
    Attached Files Attached Files
    Last edited by Howardc1001; 01-09-2019 at 01:46 PM.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Extracting range of numbers up to maximum that is in a cell

    Sorry Howardc1001,

    I am not sure what exactly you want? can you provide some sample of the desired result?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

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

    Re: Extracting range of numbers up to maximum that is in a cell

    You can put this formula in cell A2:

    =IF(ROWS($1:1)>$G$1,"",ROWS($1:1))

    then copy it down as far as you like.

    Hope this helps.

    Pete

  4. #4
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Re: Extracting range of numbers up to maximum that is in a cell

    Thanks for the help Pete, formula works perfectly

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

    Re: Extracting range of numbers up to maximum that is in a cell

    Glad to hear that - thanks for the rep (and to Arkadi).

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

    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] Extracting numbers from text in cell range and summing them up using SUMPRODUCT
    By Jakub2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2017, 07:41 AM
  2. Replies: 8
    Last Post: 05-20-2015, 10:25 AM
  3. [SOLVED] Extracting numbers only from a cell
    By warston in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-19-2013, 01:51 PM
  4. Extracting Numbers From Text Range And Sorting Numerically
    By jon87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-29-2012, 10:15 AM
  5. Extracting numbers from multiple cells in a range
    By flying_rock27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2010, 04:40 AM
  6. Replies: 2
    Last Post: 05-10-2010, 03:17 PM
  7. extracting just numbers from a cell
    By Dermot81 in forum Excel General
    Replies: 4
    Last Post: 10-09-2006, 09:37 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