I recently asked a question about linear interpolation of data for missing values. Here is the link to that question
A new problem has arisen that pertains to the case where the blank sequence ends in a blank, and not a filled value. In that case, the formula repeats the last filled value in those latest blanks. What i want to do is, have some way like conditional formatting or adding a 0.0000009 sort of number to distinguish it as stale data.
Below is the sample data:- (This data is the result of a formula that is described by the solution provided)
Date Data Updated Data
1/1/2001 1 1.000000000
2/1/2001 2 2.000000000
3/1/2001 3 3.000000000
4/1/2001 4 4.000000000
5/1/2001 4.250000090
6/1/2001 4.500000090
7/1/2001 4.750000090
8/1/2001 5 5.000000000
9/1/2001 6 6.000000000
10/1/2001 7 7.000000000
11/1/2001 7.666670090
12/1/2001 8.333330090
1/1/2002 9 9.000000000
2/1/2002 11 11.000000000
3/1/2002 11.000000090
4/1/2002 11.000000090
How can i distinguish between the last two 11s and the normal data up above? Since this data is stale and technically not the right data.?