List number of graph peaks/valleys?

[QuantEdge]

Hey all...

this one I think is impossible but I thought I will just post it out there?

Is it possible to list the peaks and valleys from a dataset? see sheet:

[sandy666]

You say - you get (joke)

[MrShorty]

As an alternative approach, I probably would have pursued some kind of "conditional formatting of chart points" approach similar to this one: https://peltiertech.com/Excel/Charts/FormatMinMax.html

[QuantEdge]

sorry sandy666, it needs to be calculated automatically nor just marked on an chart?

[sandy666]

There is note: joke
You can try Shorty's advice