Cheeks1969
New Member
- Joined
- Dec 7, 2016
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Let's say I get a datapoint of something that fluctuates over time and I enter it with a date down two columns.
I want to find the last date where it was equal to, or less than the current value. And I want to find the first time it was equal to or higher than that value.
An example might be the stock market. If I had the weekly closing Dow Avg as the data point and the date of every friday in the date column.
Say the market goes up and down and now it's crashing. I enter the closing price today and want to use that to find when it was last at this level, and when it was first at this level.
I found a solution that finds the last match, but nothing that would find the date it was last < or =. For the "first time it hit this level" it would have to be the first datapoint that is >= than current.
Thanks
I want to find the last date where it was equal to, or less than the current value. And I want to find the first time it was equal to or higher than that value.
An example might be the stock market. If I had the weekly closing Dow Avg as the data point and the date of every friday in the date column.
Say the market goes up and down and now it's crashing. I enter the closing price today and want to use that to find when it was last at this level, and when it was first at this level.
I found a solution that finds the last match, but nothing that would find the date it was last < or =. For the "first time it hit this level" it would have to be the first datapoint that is >= than current.
Thanks