E
ERB
I have an Excel worksheet that is linked to a data source that I have
no control over. Most days I get data, some days I don't. I need to
classify the data received into four different categories. Those
categories are represented below in the "Theoretical" data in the
Count column (1,2,3,4). If I received data everyday, it would be
relatively simple. Unfortunately, there are gaps in the dates that
data is received (typically weekends and Holidays). If I don't
receive data on any given date, the Count still goes on. The "Actual"
data shows what I typically get - several sequential data days, then
gaps. The proper category is shown in the "Count" column. I am
looking for a relatively elegant way of computing the "Count" in the
"Actual" data.
Theoretical Actual
Date Count Date Count
1/1/2004 1 1/1/2004 1
1/2/2004 2 1/2/2004 2
1/3/2004 3 1/5/2004 1
1/4/2004 4 1/6/2004 2
1/5/2004 1 1/9/2004 1
1/6/2004 2 1/10/2004 2
1/7/2004 3 1/11/2004 3
1/8/2004 4 1/12/2001 4
1/9/2004 1 1/13/2004 1
1/10/2004 2 1/17/2004 1
1/11/2004 3 1/18/2004 2
1/12/2004 4
1/13/2004 1
1/14/2004 2
1/15/2004 3
1/16/2004 4
1/17/2004 1
1/18/2004 2
no control over. Most days I get data, some days I don't. I need to
classify the data received into four different categories. Those
categories are represented below in the "Theoretical" data in the
Count column (1,2,3,4). If I received data everyday, it would be
relatively simple. Unfortunately, there are gaps in the dates that
data is received (typically weekends and Holidays). If I don't
receive data on any given date, the Count still goes on. The "Actual"
data shows what I typically get - several sequential data days, then
gaps. The proper category is shown in the "Count" column. I am
looking for a relatively elegant way of computing the "Count" in the
"Actual" data.
Theoretical Actual
Date Count Date Count
1/1/2004 1 1/1/2004 1
1/2/2004 2 1/2/2004 2
1/3/2004 3 1/5/2004 1
1/4/2004 4 1/6/2004 2
1/5/2004 1 1/9/2004 1
1/6/2004 2 1/10/2004 2
1/7/2004 3 1/11/2004 3
1/8/2004 4 1/12/2001 4
1/9/2004 1 1/13/2004 1
1/10/2004 2 1/17/2004 1
1/11/2004 3 1/18/2004 2
1/12/2004 4
1/13/2004 1
1/14/2004 2
1/15/2004 3
1/16/2004 4
1/17/2004 1
1/18/2004 2