List Question

M

Mike

I have a quote page where every row represents 15 minute
intervals. When one time ends, the next row starts to
update. The last column is a sum for that row. I am
trying to find a way to show the column's number from the
current row that is updating.

Row2 will update from 9:00 to 9:15 then stop updating
Row3 will update from 9:15 to 9:30 and so on...

So I want to show in cell A1, the number in r2,c4
Then when the time changes, cell A1 would show r3,c4.

Note that C4 is blank until it starts to update.

Is there an easy way to create a formula for this?

Thanks
Mike
 
R

Ryan Poth

Mike,

Assuming your column of sums is in the range D2:D100, the
following should work:

=INDEX(D2:D100,MATCH("",D2:D100,0)-1)

Regards,
Ryan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top