GROUPBY error in the array filter

[Fxingenieria]

I was triying to do this example from MrExcel, but I get a #VALUE! error. Please can you review in the file I am sending, the red sheet, I painted with yellow the formula. Thank you so much!!

 

[Fxingenieria]

I tried editing the formula and it not longer works.
You are correct; the formula fails with the filter part. It yields a value error.

Dave good morning, thank you so much for your follow up and answers. I hope with your help the Community will have an answer from Microsoft very soon.

 

[Fxingenieria]

I tried many edits and workarounds but none of them work.

I sent a feedback post to Microsoft with the inquiry.

Dave I really appreciate your help.

 

[Fxingenieria]

I tried many edits and workarounds but none of them work.

I sent a feedback post to Microsoft with the inquiry.

Dave, in other foro, one of the members answered and explaing that I am missing one ; and send this video, the function works fine for him. He sent me his file but I get the same error.

 

[Dave Patton]

I have not received any feedback.
Microsoft may have disabled this feature subsequent to the initial release; however, the help for the function still shows that it is available.
Unfortunately, none of the experts in this forum have added their input or provided a work-around.

 

[Dave Patton]

I tried Groupby today and it worked correctly.

- refresh your system; ensure that you have the latest update
- copy this sheet to a clean sheet. It may or may not translate the formula for your country.

GroupBy_PivotBy_PercentOf_Functions_2633.xlsx
	A	B	C	D	E	F	G	H	I
1								GroupBy
2	Category	Product	Sales	Cost		Category	Product	Sales	Cost
3	Fruit	Apple	1,275	689		Fruit	Apple	1,275	689
4	Vegetables	Asparagus	4,864	2,335		Fruit	Banana	3,809	1,828
5	Fruit	Banana	3,809	1,828		Fruit	Cherry	9,936	5,365
6	Herbs	Basil	8,088	3,640		Fruit	Dill	9,855	5,223
7	Vegetables	Broccoli	3,943	2,090		Fruit	Elderberry	2,768	1,439
8	Vegetables	Cabbage	2,653	1,353		Fruit	Fig	9,028	4,965
9	Fruit	Cherry	9,936	5,365		Fruit	Guava	5,385	2,854
10	Herbs	Cilantro	3,967	2,142		Fruit		42,056	22,363
11	Fruit	Dill	9,855	5,223		Vegetables	Asparagus	4,864	2,335
12	Fruit	Elderberry	2,768	1,439		Vegetables	Broccoli	3,943	2,090
13	Vegetables	Endive	7,164	3,725		Vegetables	Cabbage	2,653	1,353
14	Herbs	Fennel	9,514	4,376		Vegetables	Endive	7,164	3,725
15	Fruit	Fig	9,028	4,965		Vegetables	Peppers	8,556	3,936
16	Fruit	Guava	5,385	2,854		Vegetables		27,180	13,439
17	Herbs	Oregano	7,262	3,341		Grand Total		69,236	35,802
18	Herbs	Parsley	3,540	1,628
19	Vegetables	Peppers	8,556	3,936
20
Groupby

Cell Formulas
Range	Formula
F2:I17	F2	=GROUPBY(A2:B19,C2:D19,SUM,3,2,1,A2:A19<>"Herbs")
Dynamic array formulas.