Hello, Not sure how to label this one. I am wondering if there is a way or another formula where you can stack a number such as showing 1, 2, 3, 4 (as Cell e10 is showing) but still have those who up in different columns such as the spread sheet attached. Trying to make it a smaller document without additional copying lines.
Book1.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | |||||||||||
2 | |||||||||||
3 | JANUARY | ||||||||||
4 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | |||||||
5 | # | $ | # | $ | # | $ | # | $ | |||
6 | 2 | $329,652 | 0 | $329,652 | 0 | $329,652 | 0 | $0 | |||
7 | |||||||||||
8 | |||||||||||
9 | Number | Amount | Name | Week | Closed | ||||||
10 | ????? | $1,000.00 | John | 1, 2, 3,4 | |||||||
11 | ????? | $10,000.00 | Larry | 1 | |||||||
12 | ???? | $10,000.00 | Jim | 1 | |||||||
13 | ???? | $1,111.00 | Larry | 2 | |||||||
14 | ??? | $1,112.00 | Jim | 2 | |||||||
15 | ???? | $12,365.00 | Larry | 3 | |||||||
16 | ???? | $12,346.00 | Jim | 3 | |||||||
17 | ??? | $12,354.00 | Larry | 4 | |||||||
18 | ??? | $12,325,436.00 | Jim | 4 | |||||||
19 | |||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B6 | B6 | =COUNTIF(E10:E18,1) |
D6 | D6 | =COUNTIF(G10:G18,2) |
F6 | F6 | =COUNTIF(G10:G18,3) |
H6 | H6 | =COUNTIF(G10:G18,4) |