I have a data set with numbers in columns B, C, and D. In columns F, G, and H i would like to display the results of combining the numbers in three different configurations from columns B, C and D.
B C D F G H
8 0 6 80 86 06
F, G and H have shown all possible ways to pair the three numbers (in pairs) from columns B, C, and D
I need that process to occur from rows 4 down to row 23
To get the results in F, G and H columns i used "=SMALL(B3:D3,2)&SMALL(B3:D3,3)", seems to work but as I copy down from row 4 to row 23.
Then I need to to rank the frequency of results from F, G and H
Solved by F. Y. in 28 mins