choose minimum value

---

@YA_10963798 wrote:

can you please attach the worksheet 

 

---

Sorry, I just played around with your sheet but did not save it.

Try to retype what I had shown in the picture and if you experience problems, come back and post the sheet.

Keep in mind that what I posted only works on the second "half" of the data, the one colored red in the following picture

That's the reason I am looking for the position of the largest value in the data (the point to the far right) using the "match" function and start the loop which compares each value with its predecessor just from there.

If a similar approach should also be applied to the first "half" of the data (the blue one) you would have to use a second loop but exchange the > for a <.

EDIT: OK, I reloaded your worksheet and implemented the foregoing mentioned treatment of both data "halves" in a utility function which I called "straighten( )". I guessed that you would like to treat more than just one set of data in a similar way and so a function for doing so makes sense. You may put it anywhere in the sheet (maybe in a collapsed area) as long as its before its first usage.

If you don't want the treatment of the first data "half" you can simply delete the first for-loop.

Worksheet attached (format Prime 9)