Hi

I was trying to figure out a formula that can be used to show a list of the top 10 pairing names, along with their % value, from the far left column and top row based on the % data in the grid like in this example below:

Name Adam S Jane L Lee M Tim E Ann D

Sarah B 10% 47% 11% 85% 61%
Tom D 2% 19% 0% 20% 15%
Adrian T 27% 71% 43% 57% 8%
Peter M 0% 99% 6% 13% 33%
Amy O 95% 18% 55% 30% 2%

I know Hlookups and Vlookups would not suffice as they would return the value at interception rather than the reverse I'm looking for.

I hope someone can help me.

Kind regards
Chi