ExcelNewb09
Board Regular
- Joined
- Jan 1, 2009
- Messages
- 84
If I have the following set up:
is it possible to find the STATE which had the least or negative growth (min).
Is the same thing possible if I have This set up:?
Book1 | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
3 | State | Store | Jan'08 | Jan'09 | ||
4 | Ohio | 1 | 838.24 | 523.69 | ||
5 | Ohio | 2 | 400.51 | 627.29 | ||
6 | Texas | 3 | 823.03 | 219.65 | ||
7 | Texas | 4 | 425.84 | 376.30 | ||
8 | California | 5 | 818.26 | 299.65 | ||
9 | California | 6 | 98.37 | 301.73 | ||
10 | Oregon | 7 | 453.04 | 521.42 | ||
11 | Oregon | 8 | 93.79 | 345.68 | ||
Sheet1 |
is it possible to find the STATE which had the least or negative growth (min).
Is the same thing possible if I have This set up:?
Book1 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
3 | Date | State | Store | Sales | ||
4 | Jan'08 | Ohio | 1 | 838.24 | ||
5 | Jan'08 | Ohio | 2 | 400.51 | ||
6 | Jan'08 | Texas | 3 | 823.03 | ||
7 | Jan'08 | Texas | 4 | 425.84 | ||
8 | Jan'08 | California | 5 | 818.26 | ||
9 | Jan'08 | California | 6 | 98.37 | ||
10 | Jan'08 | Oregon | 7 | 453.04 | ||
11 | Jan'08 | Oregon | 8 | 93.79 | ||
12 | Jan'09 | Ohio | 1 | 523.69 | ||
13 | Jan'09 | Ohio | 2 | 627.29 | ||
14 | Jan'09 | Texas | 3 | 219.65 | ||
15 | Jan'09 | Texas | 4 | 376.30 | ||
16 | Jan'09 | California | 5 | 299.65 | ||
17 | Jan'09 | California | 6 | 301.73 | ||
18 | Jan'09 | Oregon | 7 | 521.42 | ||
19 | Jan'09 | Oregon | 8 | 345.68 | ||
Sheet1 |