Excel Hack 43: Use the =OFFSET() function to create dynamic ranges
Want to see how to create a list that updates automatically when you add a new item to it? These kinds of lists are called dynamic ranges. Dynamic ranges can be used to automatically generate the sums, total counts, averages, maximum and minimum values of a list you are updating in real time. We will