Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable.