@Risk: Which Iteration Produced a Given Percentile?
Open the Simulation Data window (x₁) in the Results section of the @RISK ribbon Highlight the column for that input or output Click the sort icon at the bottom of the window, and sort in descending order. Count down the appropriate number of iterations to find the information. Example: If your simulation runs 1000 iterations, then your 99th percentile would be the 11th highest one, which is the highest of the bottom 990 iterations. If this is a frequent need, you could automate the process with a RiskData( ) array function and a VBA macro.