Skip to main content

Excel - Copy Down Function



1 comment

  • Official comment
    David Paras
    • Create local variables for the following:

    1) varCurrentValue - Check if incoming value is not null, then set value to incoming value

    Holds current incoming value
    2) getContextValue - get varContext from context (get-context function)

    Holds previous value
    3) setFinalValue - Check if varCurrentValue is not null, then set value to
    varCurrentValue, otherwise set value varContext

    Set output value
    4) setContextValue - set varContext to setFinalValue variable (set-context function)

    Save current output value

    • Now set target field to setFinalValue variable

Please sign in to leave a comment.