If I have a range of data that goes up and down in value. Is there any way to
identify the cells/values where it changes from increasing to decreasing and
vice versa. I know this must be a IF statement, but I need some help. Thanks.

Example
1
2
3
4 This is a peak
3
2This is a trough
4
5
6
7
8 This is a peak
7
6
Etc.