1 Reply Latest reply on Aug 1, 2018 6:34 AM by Saikrishna Mamidi

    Copy Empty Cells with previous values

    Saikrishna Mamidi


      I have quick requirement to copy empty cells with previous value till existence of data till today.  I have used 'PREVIOUS_VALUE' function, I may have future date also, But I would like to consider till today only.  Here is screenshot, C4 should have values of DD till November 2017 because F2 has value till Nov 2017(we should ignore values in future).  Pl let me know how to write the calculation.  Thank you in advance.