Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to write Unique Solutions ONLY?
Hi everyone,
I run an optimizer n times, say 10, and tell the model to write feasible solutions into an excel table as follows: RUN Cost Weight Volume 1 2.3 51.27 20.3 2 3.1 49.2 22.2 3 4.3 37.2 16.7 4 2.3 51.27 20.3 5 6 and so on. As you see solutions 1 and 4 are duplicate which I don't want. How can I write a piece of VBA code to prevent this? In other words, the table should like this: RUN Cost Weight Volume 1 2.3 51.27 20.3 2 3.1 49.2 22.2 3 4.3 37.2 16.7 4 and so on. Regards, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula with many solutions. | New Users to Excel | |||
Ensure unique solutions to random formula | Excel Worksheet Functions | |||
lookup & match solutions | Excel Worksheet Functions | |||
Using VBA, how to write unique solutions only? | Excel Programming | |||
Looking for Solutions | Excel Programming |