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

John Bartow jbartow at winhaven.net
Sun Mar 7 14:53:50 CST 2021

```I'm going to try to clarify my goal in regards to my question.

I have 3 columns of data which currently reside in Excel - but that was just a convenient way to get them into digital format. They data are all numerical and never less than zero.  They can have a maximum of 2 decimal points.

What I'm specifically looking for is a way to evaluate the three columns of each row to find the best balance of numbers between the three columns. Having all 3 numbers be exactly the same is best. Having 2 numbers the same and one number be plus or minus one would be next best, etc.

I am thinking that this would be a solution of "standard deviation" but I am not sure.

Just trying to avoid going down a rabbit hole. So I turn to the people I know have better brains than I.
John B
-----Original Message-----
From: dba-Tech <dba-tech-bounces+jbartow=winhaven.net at databaseadvisors.com> On Behalf Of John Bartow
Sent: Sunday, March 07, 2021 1:22 PM
To: Discussion of Hardware and Software issues <dba-tech at databaseadvisors.com>
Subject: Re: [dba-Tech] finding the most consistent combination of 3 columns

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
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