I am trying to put the #of units in column F under the last item in column C. So in other words for store #3 I would like to put 10 under the last part in column C. In this case it would go under the 6 in the Tonnage. Same thing for 4 and so on. I need the formula if possible to put in the correct amount from Column F under the last item in column C in each corresponding store.
Store Trial.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | STORE # | AGE | TONNAGE | Store | # of Units | |||
2 | 3 | 2000 | 15 | 3 | 10 | |||
3 | 3 | 2000 | 10 | 4 | 14 | |||
4 | 3 | 2000 | 10 | 6 | 12 | |||
5 | 3 | 2000 | 10 | 7 | 10 | |||
6 | 3 | 2000 | 15 | 8 | 11 | |||
7 | 3 | 2000 | 15 | 11 | 8 | |||
8 | 3 | 2000 | 15 | 12 | 14 | |||
9 | 3 | 2000 | 15 | 14 | 17 | |||
10 | 3 | 2000 | 15 | 15 | 13 | |||
11 | 3 | 2000 | 6 | 16 | 10 | |||
12 | 17 | 10 | ||||||
13 | 19 | 11 | ||||||
14 | 4 | 2005 | 20 | 20 | 5 | |||
15 | 4 | 2005 | 5 | 21 | 3 | |||
16 | 4 | 2005 | 12.5 | 22 | 4 | |||
17 | 4 | 2005 | 20 | 23 | 11 | |||
18 | 4 | 2005 | 5 | 24 | 5 | |||
19 | 4 | 2005 | 20 | 25 | 14 | |||
20 | 4 | 2005 | 15 | 26 | 11 | |||
21 | 4 | 2005 | 15 | 28 | 11 | |||
22 | 4 | 2005 | 17.5 | 30 | 10 | |||
23 | 4 | 2005 | 10 | 31 | 11 | |||
24 | 4 | 2005 | 5 | 32 | 9 | |||
Sheet1 |