dimanche 20 octobre 2019

Seeking First High in Column

Not needing max value in array, but rather first high. For me, a high must be greater than the one following (next row up) and greater than the one preceding(next row down) less one.

I have two examples in this sheet, but don't know how to structure a single cell formula to return desired result. https://docs.google.com/spreadsheets/d/185zQHX0P2KC41DBuHHbv7K4onCdroTDKjT0DSKSM1IU/edit?usp=sharing

Listed in the sheet examples.

Aucun commentaire:

Enregistrer un commentaire