hi,
In the following spreadsheet i have got a series of daily prices form the nasdaq. In column I, i wrote a formula that will tell me in each day when the value in column h is equal or bigger than 0.7%. I would like to know how could i get ( maybe in a new column) each time the formula to give me the first time it crosses or equlas 0.7% ( the threashold) and wont continue to give me the value throughout the same day.
thanks in advance,
Hidai
Bookmarks