Using VBA: Avoiding Writing Down Duplicate Solutions
Hi,
Say I am running a solver 10 times, everytime a solution with 3
components is written into excel table like this
A B C
2.3 3.5 1.4
13.1 4.5 0.5
7.5 6.5 3.2
2.3 3.5 1.4
..
..
and so on. Note that the 1st and 4th solutions are duplicate. I need a
piece of detailed VBA code please that AVOIDS writing-down dupliacte
solutions. So things might look as:
A B C
2.3 3.5 1.4
13.1 4.5 0.5
7.5 6.5 3.2
..
..
Thanks alot,
Mike
|