Rank tasks in order of highest priority

[afishi0nado]

Hi,

I would like the spreadsheet in the photo to show a list of the tasks when they are highest priority.

I will manually fill in the a-b, a-c, as which is highest priority and then sum up at the bottom (at present using countif).

I would then like the list in cell b15 to show the highest task and link back to the task name, I have tried:

=if(($A$12=LARGE($A$12:$I$12, M1)),$B$1,if($B$12=LARGE($A$12:$I$12, M1),$C$2, if($C$12=LARGE($A$12:$I$12, M1),$D$3,if($D$12=LARGE($A$12:$I$12, M1),E4,if($E$12=LARGE($A$12:$I$12, M1),F5,if($F$12=LARGE($A$12:$I$12, M1),G6,if($G$12=LARGE($A$12:$I$12, M1,H7,if($H$12=LARGE($A$12:$I$12, M1),I8,if($I$12=LARGE($A$12:$I$12, M1),J9,if($J$12=LARGE($A$12:$I$12, M1),K10)))))))))))

However, this gives an error when it gets above 4.

If there are two tasks that tie, it will also only show the first one.

Is there a way of doing all this?

I don't know how to link my spreadsheet to the post, but if you let me know how, I will do this.

Thanks for any help offered

Tony

 

[alansidman]

Use XL2BB to upload sample data and a mocked up solution.

 

[afishi0nado]

This is my spreadsheet.
I would like to rank my tasks against each other and come out with the most important task by the one that wins the most cell wars.

xl2bb.xlsx
	D
17	=if(($A$12=LARGE($A$12:$I$12, M3)),$B$1,if($B$12=LARGE($A$12:$I$12, M3),$C$2, if($C$12=LARGE($A$12:$I$12, M3),$D$3,if($D$12=LARGE($A$12:$I$12, M3),E6,if($E$12=LARGE($A$12:$I$12, M3),F7,if($F$12=LARGE($A$12:$I$12, M3),G8,if($G$12=LARGE($A$12:$I$12, M3,H9,if($H$12=LARGE($A$12:$I$12, M3),I10,if($I$12=LARGE($A$12:$I$12, M3),J11,if($J$12=LARGE($A$12:$I$12, M3),K12)))))))))))
Sheet1

 

[alansidman]

You have provided only one line of data. When posting, highlight the entire range you wish to show before selecting XL2BB.