Last time entry in limited column

P

pkley

My last time on the timesheet will always equal the last time out in the next column. I can't use the standard formulas I've found here because they refer to an entire column which doesn't work because the last value in the TIME OUT column is my final time home, not my final time out of a job. I need A40 to equal the last entry of C14:D39 (merged column)
 
P

pkley

nevermind, just had to change the formula to ignore the merged cells and go with the first column only...
 

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

Similar Threads

Go to cell below last entry in column and total 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Time Sheet Summary 1
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
Single Weekly Time Sheet 0
Last Row used in calculation 4
Formula to display last entry in a column populated with #N/As 4

Top