Help finding and returning the 2nd to last value in a column, and additional calculations based on this value.

smileytmroper

New Member
Joined
Aug 27, 2008
Messages
32
I do a lot of repetitive calculations and data entry in my spreadsheet for tracking feed consumption on animals. Getting it figured out on some formulas and automation but am hung up at one point.
Referencing the pic I attached. In cell r314 I want it to pull the date from the previous row (time) there was data entered so the result of the formula should say September 1, which is cell p307. There isn't always a set amount of time between data entries. Sometimes its once a week, sometimes several weeks go by. Then in cell S314 it should take the amount from the cell next to the previous date, so next to Sept 1 it says 8324, cell q307, but again this can change, depends on when I measure feeders. So take q307 and add any deliveries that were made between the previous entry, including the day of the previous entry, up to the current entry. I was thinking using LOOKUP, but can't figure it out for sure. Also, FYI column P is an IF formula where if there is a value in column J it brings the date of that entry. Thanks
Capture.JPG
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

smileytmroper

New Member
Joined
Aug 27, 2008
Messages
32
I forgot to mention that I do this on 15 sheets which is where the repetitive part comes in. Thanks
 

Forum statistics

Threads
1,144,158
Messages
5,722,824
Members
422,460
Latest member
VBA_Noob01

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