I'm looking to use Excel formulas only, no VBA/Macros/Names/Addons.
I want to be able to automatically (maybe after 1 - 5 iteration cycles) calculate how many iterations are being done in a iteration cycle. The workbook I'm working on is one I would like to make publicly available, but with that comes varying iteration settings. I want to make sure that the right number of calculations are being done per cycle; so if there are 100 per cycle, the calculations might happen 5 times (every 20 iterations), but if there are only 20 per cycle, it would need to calculate every 4 iterations.
I understand if this is a bit complex sounding.
I want to be able to automatically (maybe after 1 - 5 iteration cycles) calculate how many iterations are being done in a iteration cycle. The workbook I'm working on is one I would like to make publicly available, but with that comes varying iteration settings. I want to make sure that the right number of calculations are being done per cycle; so if there are 100 per cycle, the calculations might happen 5 times (every 20 iterations), but if there are only 20 per cycle, it would need to calculate every 4 iterations.
I understand if this is a bit complex sounding.