I have been trying to find an example of the OFFSET formula for a dynamic range for data stored in rows and not columns. For example Date is stored in row A (A3:Z3) and Score stored in row B (B3:Z3). All I can find is examples of data in columns. What I am trying to accomplish is to create a dynamic chart that the user can manipulate to show the range of dates they are interested in viewing.
I had an example of the Offset where it took into account the fact that the data row will contuniune to grow as time goes by.
Any examples and/or quidance would be extremely helpful.
I had an example of the Offset where it took into account the fact that the data row will contuniune to grow as time goes by.
Any examples and/or quidance would be extremely helpful.