Create dynamic range formula - Excel function Offset with COUNTA or Index with COUNTA

Dynamic ranges are also known as expanding ranges - they automatically expand and contract to accommodate new or deleted data.
We are discussing how to create formulas with dynamic range on the worksheet without Macro.
One popular method is to use the OFFSET function together with the COUNTA function.
Another method is to use INDEX function in combination with the COUNTA function.
This discussion is based on the former case while the dynamic range formula with the latter case is presented also.
The example is to create monthly progress curve data table referring to the daily raw progress data.
To make the monthly data table from scratch, the following functions are discussed as well.
sum if, sum, offset, count a, column, unique, transpose, if .
You can visit the url below to download worksheet.
www.kingstones...
The example is to create monthly progress curve data table referring to the daily raw progress data.
To make the monthly data table from scratch, the following functions are discussed as well.
sum if, sum, offset, count a, column, unique, transpose, if .