Closing Value Advanced
There is an Excel file that teaches how to perform the Closing Value Advanced operation.
Excel Template for Closing Value Advanced
This workbook demonstrates closing value advanced using VBA macros on a 266-row data layout.
Hope it is useful.