moving range column

  1. T

    Help Please, Need A Formula to Capture Ever Moving Range of Data

    Hello, So I have an excel sheet with two tabs of data. The first sheet(Scorecard) is basically a summary tab linking certain data from a second sheet (SC Data) in a more presentable format. My data on the second sheet (SC Data) is updated every month through a linked table from SAP. Every...
  2. D

    Code for moving average range in Column

    Hi, Im wondering if it's possible to write a code to record a moving range in column D taking into consideration only the LAST 30 entries? Hopefully Im explaining myself correctly. If column has say 50 values, I would like Cell E1 to show the latest calculated moving range. In this instance...

Some videos you may like

This Week's Hot Topics