Mmpsychosis
New Member
- Joined
- Apr 23, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
- MacOS
This is probably super simple, but I want to confirm I'm doing the right thing here.
Basically i want to be able to detect if the numbers below are on a basic upward or downward trajectory over this 5 day period. So over the course of those 5 days, are the numbers increasing or decreasing? It would be rolling, so as I add more data, it would be looking at 3/2 - 3/6, etc... My thought was to a simple SLOPE(B1:B5,A1:A5) in C5, and then copy that forward with each subsequent new data row. Would that be the right way to do this?
My data:
Basically i want to be able to detect if the numbers below are on a basic upward or downward trajectory over this 5 day period. So over the course of those 5 days, are the numbers increasing or decreasing? It would be rolling, so as I add more data, it would be looking at 3/2 - 3/6, etc... My thought was to a simple SLOPE(B1:B5,A1:A5) in C5, and then copy that forward with each subsequent new data row. Would that be the right way to do this?
My data:
A | B | C |
3/1/2020 | 767 | |
3/2/2020 | 936 | |
3/3/2020 | 554 | |
3/4/2020 | 565 | |
3/5/2020 | 396 |