Okay so I have an ever growing column of data that gets one new data point added each month.Sometimes the database I'm using gives me a #NUM! instead of a value if there is no available data point in that month. I have a formula that was working but I want to expand it to go down a ton of rows below the last data point so that I don't have to update it everytime a new months data point is added. I've attached an example. Any help would be much appreciated
Cheers!
Bookmarks