Return Dates From Row 1 depending upon the data in rows beneath...

Hi All,

I need some assistance to be able to populate dates from Row 1 of the spreadsheet attached based on the cell values in the following rows.

Basically, I want to get the date for all rows in Column R that has the last value greater than '0' from Row 1. For ease of understanding, I've highlighted them in yellow and have manually populated the corresponding (required dates) in Column Q.

Please advise.

Thanks!

In Q2 cell

Formula:

Please Login or Register  to view this content.

Drag it down

Hope this helps!

Originally Posted by :) Sixthsense :)

In Q2 cell

Formula:

Please Login or Register  to view this content.

Drag it down

Hope this helps!

Awesome! It is working like butter:-)

I'll apply against my complete file and close the thread or seek further asistance.

Thank you.