Thanks. I'm still not sure which formula to use. Weighted Average does not work because I don't just want to weight the response of "5". But I also need to weigh the position that the "5" fell into. In the example above, for Participant #1, "5" was least important. For Participant #2 is was most important. How do I find out how option #5 ranked overall among all participants' choices?