|re: I need to count the number of days the high price of the day exceeded the high price of the previous day.|
How about this - this is just an idea, not a final solution.
In Column E, place a series of formulae similar to this:
The goal is to find the MAX for each daily list of "High Prices" and compare it to the MAX from the previous day's list.
You'll only get a 1 one for those days where the MAX value was higher than the previous day's MAX value.
Then just SUM that column.