Can I use a formula to?

mojo300

Active Member
Joined
Apr 18, 2006
Messages
301
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
 

Some videos you may like

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.

mojo300

Active Member
Joined
Apr 18, 2006
Messages
301
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
Joined
Apr 18, 2006
Messages
301
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
Joined
May 19, 2002
Messages
8,458
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,040
Messages
5,526,412
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top