# Can I use a formula to?

#### mojo300

##### Active Member
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
ABCDEF
1STORE #AGETONNAGEStore# of Units
23200015310
33200010414
43200010612
53200010710
63200015811
73200015118
832000151214
932000151417
1032000151513
113200061610
121710
131911
144200520205
15420055213
164200512.5224
1742005202311
18420055245
1942005202514
2042005152611
2142005152811
224200517.53010
2342005103111
24420055329
Sheet1

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

try a countif
=countif(A:A,E2)

#### mojo300

##### Active Member
But I have thousands of lines and i should rewrite my initial request i want to be able to put the store 3 in column D not C.

#### mojo300

##### Active Member
But I have thousands of lines and i should rewrite my initial request i want to be able to put the store #'s in column D not C.

#### texasalynn

##### Well-known Member
you just copy the formula down for all the items you show in column D. If you change where your store criteria is located, then change that part of the formula

Replies
3
Views
112
Replies
5
Views
63
Replies
2
Views
62
Replies
9
Views
79
Replies
0
Views
44