+ Reply to Thread
Results 1 to 3 of 3

Automatically update formula when a new row of data is added

  1. #1
    Registered User
    Join Date
    08-09-2013
    Location
    bangalore, india
    MS-Off Ver
    Excel 2007
    Posts
    4

    Automatically update formula when a new row of data is added

    i am trying to automatically update a formula each time a new row is added. For the columns that have a simple formula arrayformula works well, but some of the columns have a larger formula which contains larger formulas like column L2 which has the following =NOT(OR(L$1>$F2,EOMONTH(L$1,0)<$E2))*(MIN(EOMONTH(L$1,0)+1,$F2)-MAX(L$1,$E2)) the formula does not work

    I have attached the sample google sheet for your reference. i woul like column L to automatically update when a new row is added
    Attached Files Attached Files
    Last edited by hersh.patel86@gmail.; 04-20-2021 at 08:37 AM.

  2. #2
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    119

    Re: Automatically update formula when a new of of data is added

    Is it possible for you to explain in plain words what you are trying to accomplish with the formula you have in cell L2 and what your expected results are?

  3. #3
    Registered User
    Join Date
    08-09-2013
    Location
    bangalore, india
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Automatically update formula when a new of of data is added

    each guest has a checkin date E2 and checkout date F2. The formula in L2 first checks how many days of the particular booking is in the month
    of March R2 and how many days in April and so on

    For example
    Checkin Checkout Price March March Revenue April April Revenue
    31/03/2021 05/04/2021 1000 1 1000 4 40000

    the guest stays 1 day in march hence March revenue is 1000, and the guest stays 4 days in april (as checkout date is not counted) hence the
    revenue is Rs 4000


    I hope i am more clear this time around. Thank you so mcuh for your help

+ 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. Replies: 0
    Last Post: 11-03-2020, 09:11 AM
  2. [SOLVED] Need to automatically update sheet 2 as new data is added to sheet 1.
    By rafcaf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2018, 04:10 AM
  3. Replies: 1
    Last Post: 05-18-2016, 02:55 PM
  4. [SOLVED] Macro does not automatically update when a new column is added
    By zjianguk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2012, 07:44 AM
  5. Replies: 0
    Last Post: 05-16-2012, 11:57 AM
  6. Replies: 0
    Last Post: 06-21-2011, 12:47 PM
  7. How to update chart automatically as new data added?
    By hmgrts in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-01-2009, 10:28 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