This article describes the formula syntax of the MONTE.BUFFER function.


Buffer rows to ouput range from the top.



row is a row of cells to be buffered.

Over the course of a simulation it is useful to make the results of prior calculations available. XllMonte does not store any results but you can make them available in your Excel worksheet. This function buffers as many rows as the array output you specify.

Sweep out a range of cells with as many columns as the row to buffer and with as many prior rows you want to see. This is an array function so you need to use Ctrl-Shift-Enter instead of just Enter.

Over the course of the simulation each row will be pushed to the top row of the output range.