I'm hoping this is a simple question for you Excel pros out there...

I am compiling data from 200 surveys in which respondents were asked to
rank their top 10 items from a list. How can I analyze this data to
determine the overall rankings of the items? I am envisioning that
each row will have each respondent's #1 item, the next row #2, etc.,
but not sure how to actually analyze the data.

Thanks a lot.


--
NickyV
------------------------------------------------------------------------
NickyV's Profile: http://www.excelforum.com/member.php...o&userid=33696
View this thread: http://www.excelforum.com/showthread...hreadid=534718