I am brand new to the forum, and this problem has driven me to sign up. I love to learn new things in excel, and hopefully someone can help me with my problem below.

I have a data range D19:J200.

Column D has dates in it. Column J has numbers. I need to find the last value in J that is not zero, and return the date that corresponds to the row.

7/7/2007 0 0 0 0 0 0
7/14/2007 0 0 0 0 0 0
7/21/2007 0 1 0 0 1 1

For instance, I would need to return 7/21/2007 because the lower right value is not zero. Typically I am able to google the answer and figure it out and apply to my situation, but I am coming up with nothing. Really appreciate the help.