smileytmroper
New Member
- Joined
- Aug 27, 2008
- Messages
- 35
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
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
