title: Cannot find Price in Excel Document
body: <p>I have a list of Stock prices that i have imported into Excel. I wanted to check if a given price would have potentially been reached within the range of the Open Price and the Close price of any given day.
  For Example:
  The Price I am looking for is 11.98
  I Now want to know if within the last 100 trading days of data that I have...how many times the price of 11.98 could have appeared. With the idea that if the Open Price on a hypothetical day was 11.50 and the closing price of the same stock on that day was 12.23, then Hypothetically the price of 11.98 could have occurred). If price i am searching for (in my example, 11.98) could hypothetically have occurred in a day, I will count that as one occurrence...using my example of 100 trading days...then the maximum number of occurrences would be 100 (or once per day). I would like to do this in excel and would like help in what the formula should be. Ultimately, I would like a value representing how many times the price I am interested in has occured. THank you in advance. </p>