Excel Generators:
VLOOKUP
XLOOKUP
HLOOKUP
SEARCH
REPLACE
MATCH/INDEX
All Tools
IF Maker
SUMIFS
TEXT Maker
MATCH
XMATCH
FIND
DATEDIF
SWITCH
ARRAYTOTEXT
BYCOL
TRIMRANGE
GROUP BY
IFERROR
BINOM.DIST
STOCKHISTORY
Excel GROUPBY Function Generator
Required Arguments
row_fields (Required)
Enter cell range or array for grouping (e.g., A2:A10 or multiple columns A2:B10). This determines how your data will be grouped in the output.
values (Required)
Enter the range containing values to aggregate (e.g., C2:C10). These are the actual values that will be summarized.
function (Required)
Enter function name or lambda (e.g., SUM, AVERAGE, COUNT, or custom lambda). This determines how your values will be aggregated.
Optional Arguments
field_headers
No headers (0)
Yes, don't show (1)
Generate headers (2)
Show headers (3)
total_depth
No totals (0)
Grand Totals (1)
Both (2)
Grand Totals at top (-1)
Both at top (-2)
sort_order
Enter numbers corresponding to columns. Use negative for descending (e.g., 1, -2). Multiple columns: [1, -2] sorts first column ascending, second descending.
filter_array
Enter a range containing TRUE/FALSE values (e.g., D2:D10) to filter rows.
field_relationship
Hierarchy (0)
Table (1)
Generate Formula
Copy