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'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...
