ErnieCooper
New Member
- Joined
- Dec 22, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hello,
I'm trying to get an average of the lowest points in a set of data (average lowest stock level before a delivery comes in, truth-be-told).
I've got a macro that adds a column each day with the stock level on it and want to know the average turning point on that graph.
So far I can do it with another column and an 'if' function that looks to see whether it is lower than both the day before and the day after.
I can then averageif off that.
However, I want to be able to run an averageifs on the actual line showing the average of the numbers that are lesser than both the number before and the number after.
Can anyone help me?7
I'm trying to get an average of the lowest points in a set of data (average lowest stock level before a delivery comes in, truth-be-told).
I've got a macro that adds a column each day with the stock level on it and want to know the average turning point on that graph.
So far I can do it with another column and an 'if' function that looks to see whether it is lower than both the day before and the day after.
I can then averageif off that.
However, I want to be able to run an averageifs on the actual line showing the average of the numbers that are lesser than both the number before and the number after.
Can anyone help me?7