Finding the appropriate function

[andreaspul]

Hi. I have data in excel based on 2 sets of variables:

• groups: the west, west-leaning, non-aligned etc)
• options: western, abstain, opposite

i have already organised the data in 2 ways:

First by group and then by option, for example:
The West

	EVENT 1	EVENT 2
Western	54	2
Absent & Abstain	0	51
Opposite	0	1

West-Leaning

	EVENT 1	EVENT 2
Western	37	0
Absent & Abstain	2	19
Opposite	0	20

And the other way around, ie first by option and then by group, for example:

Western

	EVENT 1	EVENT 2
	​	​
The West	54​	2​
West-Leaning	37​	0​
Non-Aligned	32​	0​
Anti-West Leaning	18​	0​
Anti-West	0​	0​

Non-Aligned

	EVENT 1	EVENT 2
	​	​
Western	32​	0​
Absent	3​	13​
Abstain	16​	1​
Absent & Abstain	19​	14​
Opposite	0​	37​

I want to find number of events (one column = one event, and there is a large number of them) in which each option (western, absent, opposite) is the greatest between the 3 options, but do this separately for each group (the west, west-leaning etc), in order to fill in the table below. I have no idea how to do that.

NUMBER OF EVENTS	Western	Absent & Abstain	Opposite
The West
West-Leaning
Non-Aligned		for example, in this box I want to have the number of events in which "absent-abstain" was greater than "western" and "opposite", but only within the non-aligned group
Anti-West Leaning
Anti-West

I would appreciate your help! Thank you!

 

[andreaspul]

I figured it out! Please ignore the post!

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.