Excel: find and return last cell in column with data (ignoring those with no data inbetween)

Hi, I need to write a conditional formula that will look up in a 2nd worksheet the last coloumn with data (note that there will be some coloumns in the row that will have data and some that will be blank, I need the last column for that specific row to be the return result) Thanks!

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of July 20, 2014.

For more resources for Microsoft Excel