View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_27_] Michael[_27_] is offline
external usenet poster
 
Posts: 41
Default 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