Forum Discussion
Listing and counting unique values that match criteria
You have a few options here. I'd go with GROUPBY because it will allow you to apply multiple functions to the data. You may have to change the arrangement, but it handles this task well.
=LET( row_field, Tasks[Wave '#], f, row_field = rpt_filter, values, HSTACK(Tasks[Task '#], Tasks[Task '#], Tasks[Task Status]), fn, HSTACK(COUNTA, ARRAYTOTEXT, ARRAYTOTEXT), agg, GROUPBY(row_field, values, fn, , 0, , f), DROP(agg, 1) )
You have a few options here. I'd go with GROUPBY because it will allow you to apply multiple functions to the data. You may have to change the arrangement, but it handles this task well.
=LET(
row_field, Tasks[Wave '#],
f, row_field = rpt_filter,
values, HSTACK(Tasks[Task '#], Tasks[Task '#], Tasks[Task Status]),
fn, HSTACK(COUNTA, ARRAYTOTEXT, ARRAYTOTEXT),
agg, GROUPBY(row_field, values, fn, , 0, , f),
DROP(agg, 1)
)- When I click into the formula it stops working, and honestly my excel knowledge is too limited to figure out how to duplicate this.
#1 When I click into the formula it stops working
What does this actually mean/What happens?
#2 and honestly my excel knowledge is too limited to figure out how to duplicate this
- Fair enough. Looking at your previous posts you seem to run Excel 365. Please confirm or tell us which version you run + Windows or Mac?
- Assuming you run 365, if in a blank sheet you start typing: =gr do you see?:
the problem might be that you don't have the GROUPBY function (365 only and not Generally Available yet)
- 365 and no GROUPBY function.
