I can't get a VLOOKUP to work. VLOOKUP may be the incorrect function to
do what I want if what I want is even possible.

_The_Problem:_
I have input the answers to an opinion poll. Individuals rank their
opinions 1 thru 10. There are 100 possible choices, but a respondant
can only choose their top 10 and rank those ten accordingly.

Column A=the possible opinions.
Columns B-Z=the respondants on Row 1 and the 100 possible choices on
Rows 2-101.

So, B1 is the text "Arnold". Somwhere between B2-B101 will be the
numbers 1-10 and 90 empty cells.

On a seperate sheet I want to be able to put a respondants name with
their 10 repsonses beneath them from Column A. In order would be nice
as well.

Is this even possible.

Thanks for any help.


--
Cacoe
------------------------------------------------------------------------
Cacoe's Profile: http://www.excelforum.com/member.php...o&userid=28894
View this thread: http://www.excelforum.com/showthread...hreadid=567199