To generate a spreadsheet that shows the status of every rank requirement for every scout, please go to Advancement → Maintain Advancement → Export Rank Requirement Status To Excel.

This will create an Excel spreadsheet with one row for each rank requirement for each scout, as shown below.

The Date Earned column will be empty for requirements this scout has not yet completed.