Monte Carlo simulation of a sample size that used Monte Carlo

Hi All,

I need to create 1000 simulations of a Sample Size of 200 KPIs

I'm using Montecarlo / norm.inv and rand to get my sample population and I can get 200 or 200,000 no problem

But trying to create the 2nd part where it will calculate the average and min and max of a sub-population a set number of recursions is causing me challenges

I feel like there should be an easy way to do this without needing to code or having some super burdensome calculations that crush the excel

Any Advice?

Mike