Trying to count from the bottom of a column to a certain number

**davidhale87** · 03-01-2013, 01:23 PM

I am trying to add the numbers in the approach column until they add up to six. Then I want to be able to return the most recent date that happens. So I need to count up from the bottom of the column to make this happen.

Thanks for your help.

**Pauleyb** · 03-01-2013, 01:40 PM

Something like this in E2 and then drag down?
=IF(AND(SUM(B2:$B$8)>6,SUM(B3:$B$8)<=6),A2,"")

**davidhale87** · 03-01-2013, 01:59 PM

I would like to be able to put it on a different page and I will always be adding more rows of information. I am not sure how to take the result from that formula and put it on a different page with the most recent date.

**Pauleyb** · 03-04-2013, 10:52 AM

I don't know what difficulty you are encountering to 'put it on a different page'. Cut/Paste should work. Or just copy the page. Regardless, here is something that works (for me at least).

Hmmm, can't seem to add attachments this morning. I'll have to describe this, and if you can't get it to work, let me know and I'll try to post the worksheet later.

- In E1 type: Result
- In A1 type: Date
- Clear the 1 in cell D5
- Convert your data set to a table (highlight it and hit Ctrl-T).
- In cell D2 type =Table1[[#This Row],[Total Time]]+OFFSET(D2,1,0)
- (After you hit enter, that equation should autopopulate down the rest of the column)
- In cell D3 type =IF(AND(Table1[[#This Row],[Hold]]>=6,OFFSET(D2,1,0)<6),Table1[[#This Row],[Date]],"")
- (Again, after you hit enter, the equation should autopoplate down the rest of the column)
- You should now see 41292 in cell E5. Change E2:E8 to the Short Date format so it will then show 1/18/2013

To add rows, you should be able to just type at the bottom of the table and it will automatically that row to the table and carry over the equations.

**davidhale87** · 03-04-2013, 01:24 PM

The formula works great for me. I just want to be able to take the result that the formula produces where ever it may be the column and report it on a different worksheet. I am trying to use it to be able to put it in one cell that will always update as I add more approaches. So is there a way to report the result that is the only text in the column on another worksheet so that I dont have to scroll through the column to find the result. Let me know if you would like the example of what I am trying to do. I can post my whole logbook that I am working on, it is just a large file. Thanks for your help.