Hiya,

This is probably a walk in the park for most of you but I'm stumped!

I have a spreadsheet which analyses reference requests. In the character
section, feedback is requested on 10 items. Each item can be graded "good",
"satisfactory" or "needs improving". On my spreadsheet I want a sum to
auto-input the majority answer.

The data looks like this:

G H I J
Good Satisfactory Needs Improving Majority
5 10 0 0
6 4 6 0
7 2 1 7
8 5 5 0

I need a formula for column J. I also have the problem that sometimes (as in
row 8) there can be identical numbers for different levels of performance.

I have been playing about with IFs but have yet to come up with something
functional. To be honest, I'm not sure whether I'm even using the right
function for something like this.

Any help would be greatly appreciated!

Thank you.

Hi,

One solution assuming your titles are on row 4 would be

=OFFSET(F$4,,MATCH(MAX(G5:I5),G5:I5,))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Wendy-Bob" wrote:

Hiya,

This is probably a walk in the park for most of you but I'm stumped!

I have a spreadsheet which analyses reference requests. In the character
section, feedback is requested on 10 items. Each item can be graded "good",
"satisfactory" or "needs improving". On my spreadsheet I want a sum to
auto-input the majority answer.

The data looks like this:

G H I J
Good Satisfactory Needs Improving Majority
5 10 0 0
6 4 6 0
7 2 1 7
8 5 5 0

I need a formula for column J. I also have the problem that sometimes (as in
row 8) there can be identical numbers for different levels of performance.

I have been playing about with IFs but have yet to come up with something
functional. To be honest, I'm not sure whether I'm even using the right
function for something like this.

Any help would be greatly appreciated!

Thank you.