Hi all,
I have a large data set with dates in column A and the daily price percentage change of an asset in column B. Over the last 10 days, the price of the asset has fallen and I was wondering whether there is a formula of determining when the last time the pattern occurred?
I'm having to do it manually and I'm going out of my mind. Any help would be utterly appreciated
Here is my data set.
Bookmarks