I am not sure I am following exactly what you are trying to do. However, your description sounds a lot like this problem: https://www.excelforum.com/excel-for...ging-cell.html The challenge with this "circular reference" approach for the minimum is that Excel will start the "loop" with a 0 value, and 0 will always be the minimum. You need some way to "initialize" the loop to some very large positive number so that it can track the minimum from there. A good portion of the linked discussion was about how to initialize/re-initialize the loop so that the circular reference function can correctly track the minimum.