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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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
 

Forum statistics

Threads
1,141,138
Messages
5,704,497
Members
421,353
Latest member
jekoxien15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top