I am trying to extract a few different types of observations from an example data series of Heat Index (HI).
1st: The number of times the Index consecutively moves in one direction. I had some old code that referenced cell $C$110 in
"=SUM(--(FREQUENCY(IF(OFFSET($C$110,0,0,$C$3,1)<=0,ROW(OFFSET($C$110,0,0,$C$3,1))),IF(OFFSET($C$110,0,0,$C$3,1)>0,ROW(OFFSET($C$110,0,0,$C$3,1))))=N47))"
but I cannot seem to get it to work again.
2nd: I would like to be able to count the number of times the Index moves up/down by 2%,5%,10%. This could be over any number of days. Essentially, I want to count how many times the Index moves around in a relative band of values. For example, there have been no 250% moves in the data series, but there have been numerous 2%, 5%, etc moves. I am trying to quantify this over specific observation periods.
I cannot seem to find the solution to this on the forum or other websites, any help is appreciated. Many thanks!
Bookmarks