Hi everyone, new to posting on this forum so thank you for your patience.

I have a spreadsheet which has data in 7 columns and around 100 rows. I want to be able to find what two numbers appear most frequent together on each of the rows. They don’t have to appear side by side they can appear anywhere on the row. It is kind of like the mode but instead of finding which number is most frequent it is to find what two numbers appear most frequent on each row?
Sorry if the explanation is not clear it’s hard to put in words.
I have searched all around but can find a solution, any help from you excel gods would be much appreciated. Below is a sample of the data....

Thank you.....
4 11 17 28 39 45 10
16 26 29 30 36 41 21
8 12 19 24 28 42 18
4 5 9 20 27 31 34
6 10 18 26 27 34 15
14 16 20 22 31 43 24
4 9 24 25 29 44 39
1 11 14 16 18 23 13
2 12 15 29 34 35 16
2 3 6 14 24 26 38
7 9 21 29 30 36 13
1 10 17 18 43 44 24
1 18 22 26 35 40 17
5 14 16 26 34 40 15
4 5 15 25 28 33 35
2 7 12 15 26 28 45
9 11 17 24 33 41 36
2 21 24 32 36 40 20