Results 1 to 9 of 9

OFFSET: stay in range

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2021
    Location
    Vienna, Austria
    MS-Off Ver
    Microsoft Professional Plus 2019
    Posts
    4

    Red face OFFSET: stay in range

    Hello,


    I need a chart which predicts when a product is ready for harvest.

    production date + amount of grow days = Production output date

    For this I use the OFFSET function

    The issue is, as I have to use a negative number to reference the growth date in the past, I get results out of the range C3:H5.
    Screenshot_1.png


    How do I limit the OFFSET function to the range C3:H5?


    Any help is greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Offset Alters Entire Range, Need To Offset A Single Cell
    By Genus Max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2020, 10:47 AM
  2. [SOLVED] Help! - Copy Range (Sheet1,A10:F50), Paste Range (Sheet 2,A1:F41), Offset Range & Repeat
    By cjtimmer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 06:27 PM
  3. [SOLVED] Need cell range to stay the same
    By HeatherBelle79 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-16-2015, 08:12 AM
  4. Number should stay in a certain range
    By BOB202 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 05:12 AM
  5. [SOLVED] Define new range names based on existing range name offset 1 column to right
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2014, 07:53 PM
  6. Need Max(Cell Range) to stay the same
    By miekewl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2011, 03:04 AM
  7. Replies: 2
    Last Post: 08-22-2005, 01:05 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