Spreadsheet: 832191d1686170411-using-sortby-with-nested-filter-to-sort-two-columns-sample
Sheet: Totall DebtNowPri

 |  |  | #2 | # [NAME] list without blank Creditor 'name' entries |  | 0 |  |  |  |  |  |  |  |  | [NAME] (Alphabetically) |  |  |  |  |  |  |  |  |  | B |  | Sorted (by APR, then balance) |  |  |  | Sorted (by balance)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #1 | Creditor | Current APR | Current Balance(s) | Available Credit | Credit Limit(s) | Positive [NAME] | Due Date | Pay down to get 50% | Pay down to get 30% |  |  | #4 | Creditor | Current APR | Current Balance(s) |  | Creditor | Current APR | Current Balance(s)
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | A1 | 0.0999 | 486.55 |  | 4700 | 68.75 | xx/14 |  |  |  |  |  | S2 | 0.2999 | 2255.61 |  |  | 0.0325 | 303968.2
 |  |  | 2 | A2 | 0.0874 | 0 |  |  |  |  |  |  |  |  | A2 | 0.0874 | 0 |  | 1000 | 0 | xx/17 |  |  |  |  |  | S1 | 0.274 | 7765.57 |  | M2 | 0.06875 | 70941.76
 |  |  | 3 | A3 | 0.0325 | 1048.43 |  |  |  |  |  |  |  |  | A3 | 0.0325 | 1048.43 |  | 2200 | 40 | [NAME] |  |  |  |  |  | T1 | 0.274 | 800.83 |  | M3 | 0.0575 | 65094.8
 |  |  | 4 | A4 | 0.061 | 62 |  |  |  |  |  |  |  |  | A4 | 0.061 | 62 |  | 4000 | 1 | xx/12 |  |  |  |  |  | U1 | 0.204 | 703.44 |  | N1 | 0.1574 | 12267.44
 |  |  | 5 | B1 | 0.18 | 1663.29 |  |  |  |  |  |  |  |  | B1 | 0.18 | 1663.29 |  | 4700 | 126.91 | xx/16 |  |  |  |  |  | B1 | 0.18 | 1663.29 |  | LL1 | 0.1136 | 8936.25
 |  |  | 6 | B2 | 0.12 | -41.24 |  |  |  |  |  |  |  |  | B2 | 0.12 | -41.24 |  | 350 | 0 | xx/13 |  |  |  |  |  | N1 | 0.1574 | 12267.44 |  | LO2 | 0.1025 | 8464.83
 |  |  | 7 | C1 | 0.095 | 173.15 |  |  |  |  |  |  |  |  | C1 | 0.095 | 173.15 |  | 3600 | 96 | xx/28 |  |  |  |  |  | L1 | 0.1445 | 991.41 |  | S1 | 0.274 | 7765.57
 |  |  | 8 | C2 | 0.0665 | 1525.04 |  |  |  |  |  |  |  |  | C2 | 0.0665 | 1525.04 |  | 1600 | 45 | xx/10 |  |  |  |  |  | C4 | 0.1325 | 2233.14 |  | M1 | 0.0475 | 6744.37
 |  |  | 9 | [NAME] | 0.0474 | 83.29 |  |  |  |  |  |  |  |  | [NAME] | 0.0474 | 83.29 |  | 6500 | 162 | xx/24 |  |  |  |  |  | LO3 | 0.1299 | 6196.18 |  | LO3 | 0.1299 | 6196.18
 |  |  | 10 | C4 | 0.1325 | 2233.14 |  |  |  |  |  |  |  |  | C4 | 0.1325 | 2233.14 |  | 7520 | 246.14 | xx/07 |  |  |  |  |  | B2 | 0.12 | -41.24 |  | LB1 | 0.1074 | 4476.34
 |  |  | 11 | C5 | 0.0445 | 1341.55 |  |  |  |  |  |  |  |  | C5 | 0.0445 | 1341.55 |  | 4150 | 119.07 | xx/14 |  |  |  |  |  | LO4 | 0.1199 | 4025.8 |  | LO4 | 0.1199 | 4025.8
 |  |  | 12 | D1 | 0.082 | 0 |  |  |  |  |  |  |  |  | D1 | 0.082 | 0 |  | 7000 | 0 | xx/20 |  |  |  |  |  | LL1 | 0.1136 | 8936.25 |  | LO1 | 0.0825 | 2512.92
 |  |  | 13 | D2 | 0.074 | 543.79 |  |  |  |  |  |  |  |  | D2 | 0.074 | 543.79 |  | 10600 | 173 | xx/15 |  |  |  |  |  | LB1 | 0.1074 | 4476.34 |  | S2 | 0.2999 | 2255.61
 |  |  | 14 | H1 | 0.0699 | 0 |  |  |  |  |  |  |  |  | H1 | 0.0699 | 0 |  | 750 | 0 | xx/01 |  |  |  |  |  | LO2 | 0.1025 | 8464.83 |  | C4 | 0.1325 | 2233.14
 |  |  | 15 | J1 | 0.0199 | -0.99 |  |  |  |  |  |  |  |  | J1 | 0.0199 | -0.99 |  | 500 | 0 | [NAME] |  |  |  |  |  | A1 | 0.0999 | 486.55 |  | B1 | 0.18 | 1663.29
 |  |  | 16 | L1 | 0.1445 | 991.41 |  |  |  |  |  |  |  |  | L1 | 0.1445 | 991.41 |  | 10000 | 235.71 | xx/28 |  |  |  |  |  | C1 | 0.095 | 173.15 |  | C2 | 0.0665 | 1525.04
 |  |  | 17 | M1 | 0.0475 | 6744.37 |  |  |  |  |  |  |  |  | M1 | 0.0475 | 6744.37 |  | 8200 | 149.38 | xx/03 |  |  |  |  |  | LO1 | 0.0825 | 2512.92 |  | C5 | 0.0445 | 1341.55
 |  |  | 18 | N1 | 0.1574 | 12267.44 |  |  |  |  |  |  |  |  | N1 | 0.1574 | 12267.44 |  | 25000 | 530.63 | xx/24 |  |  |  |  |  | D2 | 0.074 | 543.79 |  | A3 | 0.0325 | 1048.43
 |  |  | 19 | S1 | 0.274 | 7765.57 |  |  |  |  |  |  |  |  | S1 | 0.274 | 7765.57 |  | 8080 | 266 | xx/15 |  |  |  |  |  | M2 | 0.06875 | 70941.76 |  | P | 0 | 1000
 |  |  | 20 | S2 | 0.2999 | 2255.61 |  |  |  |  |  |  |  |  | S2 | 0.2999 | 2255.61 |  | 2650 | 1 | [NAME] |  |  |  |  |  | C2 | 0.0665 | 1525.04 |  | L1 | 0.1445 | 991.41
 |  |  | 21 | S3 | 0.2999 | 0 |  |  |  |  |  |  |  |  | S3 | 0.2999 | 0 |  | 4500 | 0 | [NAME] |  |  |  |  |  | A4 | 0.061 | 62 |  | T1 | 0.274 | 800.83
 |  |  | 22 | T1 | 0.274 | 800.83 |  |  |  |  |  |  |  |  | T1 | 0.274 | 800.83 |  | 10300 | 322 | xx/16 |  |  |  |  |  | M3 | 0.0575 | 65094.8 |  | U1 | 0.204 | 703.44
 |  |  | 23 | U1 | 0.204 | 703.44 |  |  |  |  |  |  |  |  | U1 | 0.204 | 703.44 |  | 7000 | 296 | xx/14 |  |  |  |  |  | M1 | 0.0475 | 6744.37 |  | D2 | 0.074 | 543.79
 |  |  | 24 | LO1 | 0.0825 | 2512.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.0474 | 83.29 |  | A1 | 0.0999 | 486.55
 |  |  | 25 | LO2 | 0.1025 | 8464.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C5 | 0.0445 | 1341.55 |  | C1 | 0.095 | 173.15
 |  |  | 26 | LO3 | 0.1299 | 6196.18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M1 | 0.0325 | 303968.2 |  | [NAME] | 0.0474 | 83.29
 |  |  | 27 | LO4 | 0.1199 | 4025.8 |  |  |  |  |  |  |  |  | LO1 | 0.0825 |  |  | 30000 | 596 | xx/28 |  |  |  |  |  | A3 | 0.0325 | 1048.43 |  | A4 | 0.061 | 62
 |  |  | 28 | LB1 | 0.1074 | 4476.34 |  |  |  |  |  |  |  |  | LO2 | 0.1025 |  |  | 25000 | 600 | xx/29 |  |  |  |  |  | J1 | 0.0199 | -0.99 |  | J1 | 0.0199 | -0.99
 |  |  | 29 | LL1 | 0.1136 | 8936.25 |  |  |  |  |  |  |  |  | LO3 | 0.1299 | 6196.18 |  | 40000 | 715 | xx/30 |  |  |  |  |  | P | 0 | 1000 |  | B2 | 0.12 | -41.24
 |  |  | 30 | M1 | 0.0325 | 303968.2 |  |  |  |  |  |  |  |  | LO4 | 0.1199 | 4025.8 |  | 30000 | 645.87 | xx/15 |  |  |  |  |  | S3 | 0.2999 | 0
 |  |  | 31 | M2 | 0.06875 | 70941.76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2 | 0.0874 | 0
 |  |  | 32 | M3 | 0.0575 | 65094.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1 | 0.082 | 0
 |  |  | 33 | P | 0 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H1 | 0.0699 | 0
 |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  | LB1 | 0.1074 | 4476.34 |  | 26839.28 | 580.08 | xx/23
 |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  | LL1 | 0.1136 | 8936.25 |  | 24000 | 494.6 | xx/22
 |  |  | 36
 |  |  | 37
 |  |  | 38
 |  |  | 39
 |  |  | 40
 |  |  | 41 |  |  |  |  |  |  |  |  |  |  |  | M1 | 0.0325 | 303968.2 |  | 375000 | 2092.66 | xx/09
 |  |  | 42 |  |  |  |  |  |  |  |  |  |  |  | M2 | 0.06875 | 70941.76 |  | 86250 | 856.15 | xx/15
 |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  | M3 | 0.0575 | 65094.8 |  | 183900 | 986.31 | xx/15
 |  |  | 44
 |  |  | 45
 |  |  | 46
 |  |  | 47
 |  |  | 48
 |  |  | 49
 |  |  | 50
 |  |  | 51
 |  |  | 52 |  |  |  |  |  |  |  |  |  |  |  | P | 0 | 1000 |  | 1000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total --->
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red > 25.00% |  |  |  | Red > 30K balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total of Only CC's+Paul ---> |  |  |  |  |  |  |  |  |  |  |  | LightRed  20.00% - 24.99% |  |  |  | LightRed > 20K balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Only LOC's and Loans ---> |  |  |  |  |  |  |  |  |  |  |  | Yellow 12.00% - 19.99% |  |  |  | Yellow > 10K balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Only Mortgages ---> |  |  |  |  |  |  |  |  |  |  |  | GreenAccent6  00.00% = 14.99% |  |  |  | GreenAccent6  < 10K balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Fill when cell is blank |  |  |  | No Fill when cell is 0 or blank
 |  |  | #3 |  | 0.2999 | 2255.61
 |  |  |  | S3 | 0.2999 | 0
 |  |  |  | S1 | 0.274 | 7765.57
 |  |  |  | T1 | 0.274 | 800.83
 |  |  |  | U1 | 0.204 | 703.44
 |  |  |  | B1 | 0.18 | 1663.29
 |  |  |  | N1 | 0.1574 | 12267.44
 |  |  |  | L1 | 0.1445 | 991.41
 |  |  |  | C4 | 0.1325 | 2233.14
 |  |  |  | LO3 | 0.1299 | 6196.18
 |  |  |  | B2 | 0.12 | -41.24
 |  |  |  | LO4 | 0.1199 | 4025.8
 |  |  |  | LL1 | 0.1136 | 8936.25
 |  |  |  | LB1 | 0.1074 | 4476.34
 |  |  |  | LO2 | 0.1025 | 8464.83
 |  |  |  | A1 | 0.0999 | 486.55
 |  |  |  | C1 | 0.095 | 173.15
 |  |  |  | A2 | 0.0874 | 0
 |  |  |  | LO1 | 0.0825 | 2512.92
 |  |  |  | D1 | 0.082 | 0
 |  |  |  | D2 | 0.074 | 543.79
 |  |  |  | H1 | 0.0699 | 0
 |  |  |  | M2 | 0.06875 | 70941.76
 |  |  |  | C2 | 0.0665 | 1525.04
 |  |  |  | A4 | 0.061 | 62
 |  |  |  | M3 | 0.0575 | 65094.8
 |  |  |  | M1 | 0.0475 | 6744.37
 |  |  |  | [NAME] | 0.0474 | 83.29
 |  |  |  | C5 | 0.0445 | 1341.55
 |  |  |  | M1 | 0.0325 | 303968.2
 |  |  |  | A3 | 0.0325 | 1048.43
 |  |  |  | J1 | 0.0199 | -0.99
 |  |  |  | P | 0 | 1000