VBA : Function for Simulations

Hi guys,

I have range A1 to A5 : Each containing a function =NORM.INV(RAND(),1,1). So whenever I refresh the values would change.

I have range A6 which contains a sum of range A1 to A5 : =SUM(A1:A5) . Again, whenever I refresh the value would change.

Now, I want to create an excel function such that based on the number specified in the function( say n = 3), the function should be able to get 3 random value of range A6. Then based on that i will be able to find the average of this 3 values.

Its like refreshing 3 times and put them into an array and getting the average.

So at the moment I have something like this:

Please Login or Register  to view this content.

Really appreciate the help.

Thank You.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.