Spreadsheet: 266045d1379479012-help-comparing-arrays-to-other-arrays-book1
Sheet: Sheet1

Min | [NAME] | Avg | PD | ED | C | B | Obsolete | This is a portion of the real data.
5 | 8 | 6.5 | 0 | 0 | 0 | 0
8 | 15 | 11.5 | 10 | 5 | 0 | 5 |  | Scroll to last row for examples.
8 | 25 | 16.5 | 0 | 0 | 5 | 0
10 | 16 | 13 | 5 | 0 | 0 | 5
12 | 22 | 17 | 7 | 2 | 0 | 3
32 | 60 | 46 | 15 | 8 | 0 | 6
32 | 82 | 57 | 0 | 0 | 3 | 0
35 | 65 | 50 | 5 | 2 | 5 | 0
38 | 70 | 54 | 8 | 2 | 0 | 3
44 | 70 | 57 | 7 | 3 | 0 | 4
55 | 98 | 76.5 | 20 | 10 | 0 | 7
55 | 135 | 95 | 2 | 0 | 4 | 0
70 | 95 | 82.5 | 10 | 3 | 0 | 4
72 | 128 | 100 | 25 | 12 | 0 | 8
72 | 134 | 103 | 5 | 3 | 5 | 0
85 | 135 | 110 | 12 | 5 | 0 | 6
90 | 120 | 105 | 13 | 4 | 0 | 5
95 | 220 | 157.5 | 6 | 2 | 6 | 0
98 | 170 | 134 | 8 | 4 | 8 | 0
100 | 175 | 137.5 | 4 | 0 | 5 | 0
125 | 210 | 167.5 | 30 | 15 | 0 | 9
128 | 220 | 174 | 10 | 6 | 10 | 0
128 | 220 | 174 | 8 | 5 | 10 | 0
130 | 138 | 134 | 15 | 5 | 0 | 6
150 | 225 | 187.5 | 18 | 7 | 0 | 7
160 | 200 | 180 | 17 | 6 | 0 | 7
160 | 270 | 215 | 35 | 18 | 0 | 10
160 | 370 | 265 | 8 | 3 | 7 | 0
160 | 410 | 285 | 55 | 28 | 0 | 14
180 | 425 | 302.5 | 10 | 4 | 8 | 0
185 | 310 | 247.5 | 40 | 20 | 0 | 11
190 | 285 | 237.5 | 20 | 8 | 0 | 8
200 | 375 | 287.5 | 12 | 5 | 9 | 0
200 | 430 | 315 | 14 | 6 | 10 | 0
203 | 315 | 259 | 45 | 23 | 0 | 12
220 | 330 | 275 | 23 | 10 | 0 | 9
220 | 330 | 275 | 22 | 9 | 0 | 9
230 | 355 | 292.5 | 50 | 25 | 0 | 13
230 | 375 | 302.5 | 10 | 7 | 12 | 0
230 | 480 | 355 | 16 | 8 | 11 | 0
260 | 430 | 345 | 12 | 8 | 14 | 0
260 | 590 | 425 | 50 | 20 | 10 | 15
270 | 380 | 325 | 27 | 11 | 0 | 10
290 | 450 | 370 | 20 | 0 | 0 | 5
295 | 460 | 377.5 | 50 | 30 | 0 | 15 |  | Objective
325 | 650 | 487.5 | 18 | 10 | 12 | 0 |  | Let Excel mark each row as GOOD or OBSOLETE in column H. Examples were done by hand.
340 | 380 | 360 | 30 | 15 | 0 | 12
360 | 540 | 450 | 14 | 9 | 16 | 0 |  | Key
385 | 500 | 442.5 | 35 | 12 | 0 | 11 |  | Light green shade = GOOD. Light red shade = OBSOLETE.
385 | 500 | 442.5 | 80 | 38 | 0 | 18 |  | Obsolete: There is at least one other row in the data that has higher (or equal) values in all 7 columns. It works out that obsolete also means "there is at least one GOOD row that has higher (or equal) values in all 7 columns."
420 | 545 | 482.5 | 38 | 13 | 0 | 12
420 | 550 | 485 | 45 | 15 | 0 | 14 |  | Read examples below as numbered:
435 | 575 | 505 | 70 | 35 | 0 | 20 | OBSOLETE | 4) The row is OBSOLETE. We can compare it to a number of rows, but let's pick the very bottom row. All of this row's values are less than or equal to the corresponding values in the bottom row (note the B column is equal).
440 | 600 | 520 | 20 | 11 | 18 | 0
440 | 800 | 620 | 20 | 11 | 13 | 0 | GOOD | 3) Like in (2), we know this row is GOOD. Its [NAME] is 800, which is only bested by the bottom row (second highest [NAME] in all data). This row's C=13, beating the bottom row's C=10. No single row in the table can make this one obsolete.
460 | 600 | 530 | 85 | 40 | 14 | 18
460 | 600 | 530 | 60 | 32 | 0 | 18
480 | 680 | 580 | 22 | 12 | 0 | 0
510 | 610 | 560 | 42 | 14 | 0 | 13
510 | 620 | 565 | 100 | 50 | 18 | 15
520 | 670 | 595 | 90 | 45 | 0 | 20
530 | 700 | 615 | 90 | 45 | 5 | 20
540 | 648 | 594 | 50 | 20 | 0 | 15
540 | 790 | 665 | 25 | 15 | 15 | 0
600 | 790 | 695 | 55 | 55 | 0 | 15
610 | 700 | 655 | 100 | 50 | 0 | 22
610 | 770 | 690 | 25 | 15 | 16 | 0
615 | 750 | 707.5 | 80 | 35 | 0 | 17
640 | 725 | 682.5 | 80 | 40 | 0 | 10
650 | 680 | 665 | 50 | 50 | 10 | 15 | GOOD | 2) Notice that this row has the second highest Min=650. Its C=10, which is higher than C=5 in the row below. No row above can best Min=650. The row below cannot best C=10. Therefore, no single row can beat it in each and every column.
750 | 820 | 785 | 75 | 50 | 5 | 20 | GOOD | 1) Notice that this row has Min=750. No other row has a higher Min. Thus, we know there are no rows that can beat it in each and every column (no rows that can make it obsolete).