# Thread: How to show a list of top 10 pairing names from far left column and top row

I tested the formulas you provided by changing the % values on the sample data and there appears to be a flaw in Rank 7 & 8 as it duplicates the results. I'm not sure where the error lies.

2. Originally Posted by Chi
there appears to be a flaw in Rank 7 & 8 as it duplicates the results.
You should've taken into account all possible situations and write the expected results?
Look at my idea with the helper columns (of course you can hide this helper columns).

The array formula in the 'O' column is the following
Code:
`=IFERROR(INDEX(\$B\$1:\$F\$1;1;SMALL(IF(INDEX(\$B\$2:\$F\$6;MATCH(M2;\$A\$2:\$A\$6;0);)=L2;COLUMN(\$A\$1:\$E\$1));1));"")`
The formula in 'P' column is the next
Code:
`=IF(IF(AND(M2=M1;O1=O2);COUNTIF(\$P\$1:P1;">0")+1;0)=0;1;P1+1)`
The array formula in the 'O' column is the following
Code:
`=IFERROR(INDEX(\$B\$1:\$F\$1;1;SMALL(IF(INDEX(\$B\$2:\$F\$6;MATCH(M2;\$A\$2:\$A\$6;0);)=L2;COLUMN(\$A\$1:\$E\$1));P2));"")`
There is probably a simpler solution without extra columns but so much from me.

3. Thank you. This did the trick

Page 2 of 2 First 1 2

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•