Hi,
I have searched but can't seem to find what I am looking for, my excel skills are very basic and I was wondering if someone could help with a formula that will allow me to do the following:
I need a formula in Cell Z5 that gives me an average of the highest scores in cells R5, S5, T5, U5, V5, W5, X5, Y5. The higher the number a letter the better the score for example a 3a is higher the a 3b and so on. Any help would be much appreciated. See attached sheet.
I have searched but can't seem to find what I am looking for, my excel skills are very basic and I was wondering if someone could help with a formula that will allow me to do the following:
I need a formula in Cell Z5 that gives me an average of the highest scores in cells R5, S5, T5, U5, V5, W5, X5, Y5. The higher the number a letter the better the score for example a 3a is higher the a 3b and so on. Any help would be much appreciated. See attached sheet.