[dba-Tech] finding the most consistent combination of 3 columns

[John Bartow]

1,1,1

-John
-----Original Message-----
From: dba-Tech <dba-tech-bounces+jbartow=winhaven.net at databaseadvisors.com> On Behalf Of Gustav Brock via dba-Tech
Sent: Sunday, March 07, 2021 1:54 AM
To: Discussion of Hardware and Software issues <dba-tech at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Subject: Re: [dba-Tech] finding the most consistent combination of 3 columns

Hi John

Which set would rank first: 1,1,1 or 3,1,1?

/gustav

________________________________
Fra: dba-Tech <dba-tech-bounces+gustav=cactus.dk at databaseadvisors.com> på vegne af John Bartow <jbartow at winhaven.net>
Sendt: 7. marts 2021 06:52
Til: DBA-Tech (dba-tech at databaseadvisors.com) <dba-tech at databaseadvisors.com>
Emne: [dba-Tech] finding the most consistent combination of 3 columns

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
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com