Thanks for the input everyone
it is in fact a montecarlo simulation.. i'll try and look into other applications. just hope i can figure out how to use them properly
:-s
Hello
I need 100 000 random numbers, following a normal distribution. I tried using excel, tools, generate random numbers... the problem is: it works for 30 000, but not much more than that. I tried doing 4 times 25 000 numbers. that works, but i then need to sort all the numbers, and i cant...
i tried it and with a few changes, it works perfectly... it still didnt like the constraint = 1... so i put 1 in a column and refered it to it.
I'm not sure i understand the code, but if it works, that's all i need.
thanks a lot
i'm trying to minimize a target cell with two constraints, with formulas in different columns. the solver works fine when i do it manually, but when i try to intergrate a macro, it screws up. it ignores one of my constraints. so the result is wrong.
my second problem is that i can't figure out...
