How to conditionally return the last value in a column in Excel

Returning the past price based on a condition appears like a hard difficulty to address unless you test a person of these quick-to-implement alternatives.

Fibo Quantum