First of all, I'd like to apologyze for my poor English, but I haven't received any replies on the "Non English Excel forum" so here I am. I'll try my best to explain myself.
So, I need a sheet that contains more than one million rows. It's 10 variations with repetition of 4 elements. That's 4^10= 1.048.576 possible combinations. Also, for each combination I must obtain a probability that depends on the odds given in another sheet (same book). I also need a couple more calculations. I believe you'll see it better in the enclosed file cause I can't explain myself
The thing is I am able to generate all the possible combinations and open them in 2 separate excel sheets, but as soon as I start doing some calculations and dragging down to the bottom of the sheet, excel collapses. Is there any way to do what I want using excel?? I've seen something about Power Pivot but I'm completely lost. Don't even know if it's the right tool for the task. I tried creating a table, but as soon as I did it, all the cells that contained a formula changed the result to #N/A.
Could you please point me in the right direction?? Thanks in advance for your help.
Bookmarks