I have a single collumn of dates, and another single collumn of data as shown in the help file... the two columns are the source data for a scatter plot which is in another sheet... im trying to set a dynamic range that takes only the last month/30 days and updates the scatter plot so it shows only the last month. I've tried looking this up and I know I need OFFSET and COUNTA. Heres what I have, I'm really confused:
=OFFSET(Bid List Scatter Plot!$D$10,COUNTA(Bid List Scatter Plot!$D:$D)-30,0,30,1
can someone please help?
Bookmarks