PIVOTBY

[datastudent]

Hi,

I want to summarize my data using the PIVOTBY formula.

My data is formatted the way it shows in table 1 and I want to summarize it like in table 2.

Template_v1.xlsm
	H	I	J	K	L	M	N	O	P
1	Country	Type	DID	MRC		Country	Type	DID	MRC
2	ARGENTINA	Geographic	0	2.91		ARGENTINA	Geographic	0	2.91
3	ARGENTINA	Geographic	0	2.91		ARGENTINA	National	0	3.91
4	ARGENTINA	National	0	3.91		AUSTRALIA	Geographic	1.05	2.04
5	AUSTRALIA	National	0	1.04		AUSTRALIA	National	0	1.04
6	AUSTRALIA	Geographic	0	1.04
7	AUSTRALIA	Geographic	1.05	1.04
8	AUSTRALIA	Geographic	0	2.04
VoxDID

 

[Fluff]

You wouldn't use pivotby for that, but groupby

=GROUPBY(H2:I8,J2:K8,MAX,0,0)

 

[datastudent]

You wouldn't use pivotby for that, but groupby

=GROUPBY(H2:I8,J2:K8,MAX,0,0)

Thank you! I appreciate you!

 

[Fluff]

You're welcome & thanks for the feedback.