Comparing data columns in Excel in irregular places

Hello Everybody!

I'm trying to do some tests to allocate trends in historical data using excel. 

I've attached a picture, I'm trying to compare the boxes that say "LOW" with the previous box that says "LOW".

A bit of background information, the data is price history of the share market, if it says low, that means that the lowest price that day was lower than the lowest price on both the previous and the next day. 

What I want to do, is to find the "LOWS" with prices that are lower than the previous "LOW" - and keep the results in the same order as the LOWS, WITH the blank boxes - I cannot do this manually as there is far too much data to go through. 

In the picture there is a column with "Lower low" in it, this is exactly what I'm trying to find, however, I need it in the same order as the LOWS in order to compare it with other data later on. 

Does anyone know how I can do this? 

Thank you in advance!