S
s2m via OfficeKB.com
I work with a daily extract that has a 2 columns, which contains
both a Plan Start date(Z) and Actual Start date(AA). I am trying to build an
IF statement that will look at the Plan Start date and find if it has an
Actual Date.
I can run a pivot but I need to show it like this.
The problem I am having is that it counts any corresponding date in the
Actual column. I only want it to show if the Plan dates has been actually
started. I don't want to see any Actual numbers if there is not an Plan
number.
3/1 3/2 3/3 3/4 3/5 3/6 3/7 3/8
Plan 2 0 0 0 4 0 0 0
Actual 2 0 0 2 6 0 0 4
both a Plan Start date(Z) and Actual Start date(AA). I am trying to build an
IF statement that will look at the Plan Start date and find if it has an
Actual Date.
I can run a pivot but I need to show it like this.
The problem I am having is that it counts any corresponding date in the
Actual column. I only want it to show if the Plan dates has been actually
started. I don't want to see any Actual numbers if there is not an Plan
number.
3/1 3/2 3/3 3/4 3/5 3/6 3/7 3/8
Plan 2 0 0 0 4 0 0 0
Actual 2 0 0 2 6 0 0 4