Scan D column until numbers no longer increase, keep last high value, delete rest, repeat

Hello everyone,

The title basically describes it all. Please refer to the attached picture for the more detailed version. Would anybody know how to get this done?


Sample.JPG

Thanks for all the help!