Moving formula changing cell position

Hi, I’m dealing with the following problem. I want, given an array of values to iteratively find the minimum from the position next to the previous minimum. I’ll give an example.

Suppose I have the array (1 2 9 6 4 7 10) the minimum is 1 and it’s in the first position, so in the next iteration I’ll compute the minimum of the array (2 9 6 4 7 10). The minimum is 2 and it’s in the first position, therefore in the next iteration I’ll compute the minimum of (9 6 4 7 10). In this case the minimum is 4 and it’s in the 3rd position, so in the next iteration I’ll compute the minimum of (7 10), and so on.

I want to do this for a large number of values, so I’d like to find a formula that allows me to do this. Maybe a way to recover the address of the cell next to the one on which the minimum is attained.

Thanks in advance.

By: Esteban

Leave a Reply

Your email address will not be published. Required fields are marked *