Try array entering this. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
|
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
1 |
Data Set |
|
|
|
|
|
Summary |
|
|
|
|
2 |
|
Month 1 |
Month 1 |
Month 2 |
Month 2 |
|
|
Month 1 |
Month 1 |
Month 2 |
Month 2 |
3 |
|
Revenue |
Units |
Revenue |
Units |
|
|
Revenue |
Units |
Revenue |
Units |
4 |
Customer 1 |
31000 |
34 |
62297 |
95 |
|
Customer 1 |
51000 |
60 |
114321 |
135 |
5 |
Customer 1 |
20000 |
26 |
52024 |
40 |
|
Customer 2 |
92000 |
80 |
72982 |
94 |
6 |
Customer 2 |
16000 |
14 |
34405 |
70 |
|
|
|
|
|
|
7 |
Customer 2 |
76000 |
66 |
38577 |
24 |
|
|
|
|
|
|
Bookmarks