Hello all,
The code that previous posters have posted only works for a limited number of ranked items. If you have 12 items that participants rank and then If you would like to display the top one and two items that people ranked in a ranking question later on in the experiment you would need to come up with a different excel code. What you can do is label the top item something like "highest" and the second item as "second". I have created an excel sheet with code for the items I had participants rank. You can change the items by replacing the items I have in the quotations.
Then simply insert <highest> or <second> in subsequent questions you would like to display the highest item or second item.