Writing a ranking result in a stand alone cell

Hi

I have a table with countries and sales values, showing top 10 countries for sales, and the respective percentages of sales vs total sales.

I want to write a sentence in a standalone cell saying “The top country is XXXX with zz% followed by YYYY with oo%”

Can it be done? Is it possible to use a macro to access particular values from a table?

Many thanks!
ds9


ds9 (BOB member since 2006-04-27)