Chi
New member
- Joined
- Jun 23, 2015
- Messages
- 29
- Reaction score
- 0
- Points
- 3
- Excel Version(s)
- excel 2013
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
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