my data set is horizontal and new data is added by inserting a column in B every day ...so essentially data is being added to the left column rather than the most right column.


offset formula doesn't seem to work because the reference point changes due to the insertion of a new column (eg the reference point B2 changes to C2 after inserting a new column the next day)