AI · 1 min read

GROUPBY

GROUPBY function in Excel: Groups, aggregates, sorts, and filters data.

Excel functions / Lookup & Reference
Lookup & Reference function · Excel

GROUPBY function

Groups, aggregates, sorts, and filters data.

Availability

PlatformStatus
ExcelListed
Google SheetsNot listed
On Google Sheets: use QUERY. Rewrite as a select statement with group by.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.