Excel functions / Lookup & Reference
Lookup & Reference function · Excel
GROUPBY function
Groups, aggregates, sorts, and filters data.
Availability
| Platform | Status |
|---|---|
| Excel | Listed |
| Google Sheets | Not 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.