Hi please can someone help me?
Please view the attachment example. I am doing some Survey Analysis and have had to convert the text answers to those surveys questions into numbers.
1= Agree
2= Tend to agree
3= Neutral
4= Tend to disagree
5= Disagree
I now want to do an average of columns D to L in row 847 but as I used an IF formula to convert the text to numbers is won't let me average the cells as there is a formula in it.
I also want to do a ranking in row 849 based on the average in row 847. The lower the average the higher the ranking. This way I can analyse where we need to implement an improvement process.
Can anyone help me please?
Bookmarks