Ok thats already a good base but i am not sure if i understand the need so let me try to summarize it my way.
1. You Hit F9 and Recalculation happens
2. You want to Check if the Yellow FN is lower than the Blue FN
3. if yellow is lower than blue all the yellow values are stored in the blue area
4. if yellow is bigger than blue blue stays untouched
This way blue always holds the optimal parameters
Is that correct so far?
Edit: I made a sheet based on my assumptions so if i am right you already have something to work with.
Some information about it.
1. i set the Calculation mode of the Sheet to Manual so Calculation only happens if you press F9 this way it will not always be triggered when you change a cell.
2. I see in Column AF you have some Circula Reference Formula to count itereations that should be removed ( i did not remove it)
3. I added a counter for iterations in B252 which adds 1 every time calculation happens
4. i wrote a small script that is linked with the button "auto Iterate" it will ask you how many iterations you want to be done then calculate the sheet that many times
when it is finished it tells you in a message box how often the blue fn changed while doing the iterations and at wich iteration it changed the last time so if you do 1000 iterations for example it says
"Minfn changed 20 times in 1000 Iterations and the last change happend in Iteration 459"
Thats about it hope i understood your request correctly :D
edit2: you can remove the last msgbox from the code used it to check how long it runs with and without screen update :D
Bookmarks