Howdy!
I'm attaching an example of what I am trying to do. Column A is the current quarter, and then there are a number of different columns (10 in the example, ie finance, accounting, etc) - each column is further broken down into two columns (equity/investment and liability). As new data is added for each quarter, I need a formula that will allow me to create graphs on the LAST (ie most recent) entry. I imagine this as being a cell for each column that always displays the most recent entry, which I can then reference to create a variety of different graphs. I will of course need plenty of room to enter new data, so the formulas can't restrict this for it to be helpful
Thanks so much in advance for any help yall are able to provide!
Bookmarks