We always create range reference in formula in excel that is fixed such as $A2:$A15, if we add record, we also need to change the reference in formula.
With this dynamic range techinque, everything can be more flexible,
after using this techinque you can add records and no need to change the range reference, see this tutorial to know more.
Watch video Excel Solution - How to Create Dynamic range - example 1.avi online, duration hours minute second in high quality that is uploaded to the channel Stephen Tsui 28 October 2010. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,895 times and liked it 0 visitors.