[dba-Tech] finding the most consistent combination of 3 columns
    John Bartow 
    jbartow at winhaven.net
       
    Sat Mar  6 23:52:15 CST 2021
    
    
  
Hi All,
I am looking to find the best combination of 3 columns of numbers and then sort by the highest ranking.
For instance given the values below I want to find 5,5,5 and then 4,4,4 and then 3,2,3 and then 3,2,2.
0,4,8
5,1,1
1,3,5
3,2,3
12,0,0
0,10,0
0,0,15
4,4,4
5,5,5
3,2,2
Suggestions on how to proceed in Excel or Access.
John B
    
    
More information about the dba-Tech
mailing list