Return Column Header for First and Last Columns to Contain a Value

Hello All

First Post here.

First, let me say that I'm sorry if this has already been asked and answered. I've been googling for the past couple of hours and searching your forums as well but I can't find exactly what I'm looking for. I've found things that are similar but when I try to edit them for exactly what I need, I break the formulas as I am terrible with excel.

What I am looking for is a formula that will return the column header of the first column to contain data in a row -and- a formula to do the same but instead with the last column to contain data.

(See the cells highlighted in yellow. These are the results I would like to get)

Screen Shot 2017-05-26 at 4.53.46 PM.png

Thank you so much for the help. I have a list of 1500 supporters with 12 years of sporadic donations. I'd really like to avoid scanning each row manually.

-Chris

Thank you so much for the help sandy666! This worked perfectly!

Next time I will definitely post an excel example. I wasn't aware that I could do that.

Thanks again!
Chris

You are welcome
Thanks for the feedback and mark thread SOLVED.