Lookup formula to find last number in a column and compare to the cell above.

Hi, I use this Lookup formula to find the last number in a column which works great.
LOOKUP(2,1/(ISNUMBER($D$3:$D$648)*($D$3:$D$648<>"")),$D$3:$D$648)

I need a formula to find the last number in the column and compare it to the cell above the last entry.
If the cell value is > than the last entry to ignore the last entry but not delete it.

Please see attached sample workbook.

Thanks in advance