How to distinguish between two "stale values" and blanks in between two values in a column of data?

98 views Asked by At

I recently asked a question about linear interpolation of data for missing values. Here is the link to that question

What is the dynamic solution to a linear interpolation of data in a row with missing values with an indefinite number of missing value sequences?

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.?

0

There are 0 answers