Hi everyone,

Say I am running Excel optimizer to solve a model 10 times. Say at run
1, the solution array (it is not one value solution) is something like
this:

Cost Volume Weight Cooling
2.3 5.4 4.1 7.1

At run 2, I want to check if the 2nd solution array is same as 1st,
then don't write it down and go to the 3rd run.

At run 3, I want to check if the 3rd solution array is same as 1st OR
2nd, then don't write it down and go to the 4th run.

And so on.

How can I do so using VBA?

Thanks,
Mike