Hi everyone,
I have an Excel sheet that scores investigation outcomes based on criteria met by a series of questions.
It then looks at the highest score and returns an assumption.
My issue is that if 2 different questions score 10 (or the same score) then it will only return one assumption.
I would like a formula so i can display both assumptions in separate columns. Please see below.
I am a relative novice at excel so would like to keep the structure of sheet and not change everything. I understand that my formula is probably not the most efficient way.
In advance thank you to everyone who provides input.
Have a wonderful day
I have an Excel sheet that scores investigation outcomes based on criteria met by a series of questions.
It then looks at the highest score and returns an assumption.
My issue is that if 2 different questions score 10 (or the same score) then it will only return one assumption.
I would like a formula so i can display both assumptions in separate columns. Please see below.
I am a relative novice at excel so would like to keep the structure of sheet and not change everything. I understand that my formula is probably not the most efficient way.
In advance thank you to everyone who provides input.
Have a wonderful day
