I put in a helper column, starting one line below the top of your data, and
ending one above your last line. I then put in e.g. line G2
=IF(AND(F1<F2,F3<F2),F2,FALSE)
Then copy down.
This makes a column with only the maximum values, similar for minimum values.
You could also track the last maximum
=IF(AND(F1>F2,F3>F2),F2,F1)
satellitemax
Y
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.