Displaying 2 results from an estimated 2 matches for "sonicstats11".
2008 Jul 22
2
Help with rearranging data
In Excel, I have data that looks like this.
Month
Seg
Prod
Biller
Cycle
Sales
1/1/2008
A
Table
Phyllis
1
500
1/1/2008
A
Table
Phyllis
2
600
1/1/2008
A
Table
Phyllis
3
650
1/1/2008
A
Table
Doreen
1
345
1/1/2008
A
Table
Doreen
2
451
1/1/2008
A
Table
Doreen
6
550
1/1/2008
A
Table
Doreen
9
590
1/1/2008
A
Table
Doreen
11
860
1/1/2008
A
Chair
Phyllis
1
300
1/1/2008
A
Chair
Phyllis
2
350
2008 Aug 14
1
Moving Average Question
Dear all. I have data that looks like this:
Biller Cycle Jan Feb Mar Apr May JuneAB 1 100 150 150 200 300 450JL 2 650 600 750 700 850 800JL 3 700 740 680 690 700 580IR 1 455 400 405 410 505 550IR 4 600 650 700 750 650 680IR 5 100 150 120 130 140 190IR 9 600 640 630 625 680 690
For each biller and cycle, I want to determine the six