On the ‘Enrolment Summary’’ worksheet, name the range A3:B7 ‘’Enrollment’’,
Check the Solution below.
Select the range and type the name
On the ‘’Region 1’’ worksheet, perform a multi-level sort, Sort table data by ‘’Product’’ (A to Z) and then by ‘’Total Sales’’ (Largest to Smallest).
Click sort and filter. Press custom sort and add levels to sort by.
TESTED 21 Nov 2024
