Spreadsheet: 704267d1605470172-vlookup-avoiding-rows-with-specific-criteria-example-2
Sheet: Sagarin

 | SAGARIN
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  |  |  |  | VS TOP 10 |  |  | VS TOP 16
# | NAME | RANK | W | L | T | SCHED RK | RANK | W | L | T | W | L | T | PRED | GOLD | RECENT
12 | Arizona Cardinals | 21.5 | 5 | 3 | 0 | 18.04 | 31 | 1 | 1 | 0 | 2 | 1 | 0 | 21.84 | 20.59 | 22.07
19 | Atlanta Falcons | 19.27 | 3 | 6 | 0 | 18.97 | 27 | 0 | 2 | 0 | 1 | 2 | 0 | 18.45 | 18.58 | 20.67
2 | Baltimore Ravens | 26.42 | 6 | 2 | 0 | 20.37 | 14 | 0 | 2 | 0 | 1 | 2 | 0 | 27.72 | 26.58 | 25.41
8 | Buffalo Bills | 22.49 | 7 | 2 | 0 | 20.06 | 18 | 3 | 1 | 0 | 4 | 2 | 0 | 21.44 | 23.07 | 23.02
24 | Carolina Panthers | 17.58 | 3 | 6 | 0 | 21.71 | 2 | 0 | 3 | 0 | 1 | 4 | 0 | 17.91 | 17.07 | 17.67
20 | Chicago Bears | 19 | 5 | 4 | 0 | 20.47 | 11 | 1 | 2 | 0 | 1 | 4 | 0 | 18.95 | 19.25 | 18.75
25 | Cincinnati Bengals | 17.28 | 2 | 5 | 1 | 19.83 | 20 | 0 | 1 | 0 | 1 | 2 | 0 | 16.01 | 15.95 | 15.26
18 | [NAME] | 19.71 | 5 | 3 | 0 | 20.06 | 17 | 0 | 2 | 0 | 1 | 3 | 0 | 18.63 | 20.45 | 19.96
27 | Dallas Cowboys | 16.53 | 2 | 7 | 0 | 20.15 | 16 | 0 | 3 | 0 | 0 | 4 | 0 | 17.62 | 17.34 | 13.37
22 | Denver Broncos | 18.06 | 3 | 5 | 0 | 20.83 | 6 | 0 | 3 | 0 | 0 | 4 | 0 | 17.6 | 18.21 | 18.29
28 | Detroit Lions | 16.48 | 3 | 5 | 0 | 20.49 | 10 | 0 | 2 | 0 | 1 | 4 | 0 | 16.45 | 16.57 | 16.37
7 | Green Bay Packers | 23.23 | 6 | 2 | 0 | 20.53 | 9 | 1 | 1 | 0 | 3 | 2 | 0 | 24.22 | 23.17 | 22.43
26 | Houston Texans | 16.61 | 2 | 6 | 0 | 21.08 | 4 | 0 | 4 | 0 | 0 | 6 | 0 | 16.65 | 16.58 | 16.54
11 | Indianapolis Colts | 21.6 | 5 | 3 | 0 | 17.72 | 32 | 0 | 1 | 0 | 1 | 1 | 0 | 22.21 | 21.11 | 21.45
32 | [NAME] | 11.07 | 1 | 7 | 0 | 18.71 | 29 | 0 | 1 | 0 | 1 | 2 | 0 | 10.75 | 10.66 | 11.61
1 | Kansas City Chiefs | 27.52 | 8 | 1 | 0 | 18.93 | 28 | 2 | 0 | 0 | 2 | 1 | 0 | 28.38 | 28.41 | 26.38
15 | Las Vegas Raiders | 21.29 | 5 | 3 | 0 | 21.85 | 1 | 2 | 2 | 0 | 2 | 2 | 0 | 20.06 | 20.93 | 23.03
23 | Los Angeles Chargers | 18.04 | 2 | 6 | 0 | 20.38 | 12 | 0 | 3 | 0 | 0 | 4 | 0 | 19.03 | 17.84 | 17.08
10 | Los Angeles Rams | 21.61 | 5 | 3 | 0 | 19.2 | 25 | 0 | 2 | 0 | 0 | 3 | 0 | 22.09 | 21.64 | 21.08
9 | [NAME] | 21.66 | 5 | 3 | 0 | 19.26 | 24 | 1 | 2 | 0 | 3 | 2 | 0 | 21.23 | 19.92 | 24.41
16 | Minnesota Vikings | 19.95 | 3 | 5 | 0 | 20.68 | 7 | 1 | 2 | 0 | 1 | 4 | 0 | 20.43 | 19.82 | 19.55
21 | New England Patriots | 18.99 | 3 | 5 | 0 | 21 | 5 | 1 | 3 | 0 | 2 | 4 | 0 | 19.32 | 19.96 | 17.53
3 | New Orleans Saints | 25.86 | 6 | 2 | 0 | 20.38 | 13 | 2 | 1 | 0 | 2 | 2 | 0 | 24.98 | 25.77 | 27.25
29 | New York Giants | 15.84 | 2 | 7 | 0 | 19.91 | 19 | 0 | 3 | 0 | 0 | 4 | 0 | 15.95 | 15.11 | 16.3
31 | New York Jets | 11.88 | 0 | 9 | 0 | 21.61 | 3 | 0 | 4 | 0 | 0 | 7 | 0 | 11.52 | 12.29 | 11.68
17 | Philadelphia Eagles | 19.84 | 3 | 4 | 1 | 19.74 | 22 | 0 | 3 | 0 | 1 | 3 | 0 | 20.16 | 20.13 | 19.17
4 | Pittsburgh Steelers | 25.45 | 8 | 0 | 0 | 19.18 | 26 | 1 | 0 | 0 | 2 | 0 | 0 | 24.14 | 25.66 | 27.34
14 | San Francisco 49ers | 21.32 | 4 | 5 | 0 | 19.76 | 21 | 1 | 3 | 0 | 1 | 4 | 0 | 22.92 | 22.15 | 19.1
6 | [NAME] | 23.35 | 6 | 2 | 0 | 20.23 | 15 | 1 | 1 | 0 | 3 | 2 | 0 | 23.55 | 24.08 | 22.5
5 | Tampa Bay Buccaneers | 23.68 | 6 | 3 | 0 | 20.56 | 8 | 1 | 2 | 0 | 2 | 2 | 0 | 24.24 | 24.23 | 22.7
13 | Tennessee Titans | 21.44 | 6 | 2 | 0 | 18.64 | 30 | 1 | 1 | 0 | 2 | 1 | 0 | 20.69 | 21.85 | 21.76
30 | Washington Redskins | 15.45 | 2 | 6 | 0 | 19.45 | 23 | 0 | 2 | 0 | 0 | 3 | 0 | 14.88 | 15.01 | 16.25