+ Reply to Thread
Results 1 to 4 of 4

Formula to include changing range

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    Wales, UK
    MS-Off Ver
    365
    Posts
    66

    Formula to include changing range

    The macro will fill in the formulas in specified cells but how can I change it to include the whole range(Marked red) which will vary every month?

    Example:

    Please Login or Register  to view this content.
    Last edited by Simone Fick; 07-26-2017 at 05:42 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,212

    Re: Formula to include changing range

    you shall somehow find which row your data ends.
    It would be easier to give a good suggestion seeing your worksheet. but assuming (for your first problematic range) that you have continuous set of data in column C which you want to rank, you could use:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-15-2014
    Location
    Wales, UK
    MS-Off Ver
    365
    Posts
    66

    Re: Formula to include changing range

    I've changed some of the columns but it gives me an error" Type mismatch" on the last code line

    Please Login or Register  to view this content.
    But I've figured out the problem, the "*" in the last row should change to a "&", below is the working code, thanks for the help.

    Please Login or Register  to view this content.
    Last edited by Simone Fick; 07-26-2017 at 05:42 AM. Reason: Problem found and fixed

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,212

    Re: Formula to include changing range

    Sure, obvious typo. But as there was no attachment I've not tested it.
    Glad you noticed and corrected. Thanks also for marking thread solved and for rep. point

+ 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. Need MAX formula to include column references from changing ranges
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-11-2016, 04:36 PM
  2. If formula that can include text within a range
    By jlazo06 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2015, 03:27 PM
  3. Insert formula to include entire range
    By EthanM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2015, 11:51 AM
  4. [SOLVED] Dynamically Extending the Range, in a Formula, to Include Added Rows
    By Raabi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2014, 10:37 AM
  5. how to include name range in nested if formula
    By shilpaduneja in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2013, 08:35 AM
  6. Replies: 1
    Last Post: 02-09-2012, 04:13 AM
  7. Formula to include inserted cell range
    By gandolff in forum Excel General
    Replies: 3
    Last Post: 10-12-2009, 04:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1