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