Spreadsheet: 67258d1267833903-how-to-reference-the-result-of-a-filter-exampleworkbook
Sheet: Data

Name | Group | Year | Make | Model | Trim | Trim Retained Value | [NAME] | Make Retained Value | Segment Retained Value | Year Retention | Trim Rating vs. Group | [NAME] vs. All Models | Make Rating vs. All Makes | Group Rating vs. MY Average | Total Vehicle Rating | Trim vs. Group Percentile | Total Vehicle Rating Percentile
2001 Acura Integra LS Sport Coupe 2D | [NAME] | 2001 | Acura | Integra | LS Sport Coupe 2D | 0.2560953883742238 | 0.2756357609182377 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.312339153573232 | 1.314532766058348 | 1.344099753223844 | 0.9306610227090208 | 2.157945781521514 | 0.932 | 0.935
2001 Acura Integra LS Sedan 4D | [NAME] | 2001 | Acura | Integra | LS Sedan 4D | 0.2419018916005098 | 0.2756357609182377 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.239605780041953 | 1.314532766058348 | 1.344099753223844 | 0.9306610227090208 | 2.038346609188436 | 0.892 | 0.92
2001 [NAME] 3.5 Sedan 4D | [NAME] | 2001 | Acura | RL | 3.5 Sedan 4D | 0.1883505973472269 | 0.1883505973472269 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 0.9651867027627866 | 0.8982616438983627 | 1.344099753223844 | 0.9306610227090208 | 1.084519118609071 | 0.463 | 0.582
2001 Acura CL 3.2 Type S Coupe 2D | [NAME] | 2001 | Acura | CL | 3.2 Type S Coupe 2D | 0.2157820712117847 | 0.2058432245814934 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.105756970041771 | 0.9816856219311291 | 1.344099753223844 | 0.9306610227090208 | 1.357860461619456 | 0.745 | 0.731
2001 Acura Integra GS Sport Coupe 2D | [NAME] | 2001 | Acura | Integra | GS Sport Coupe 2D | 0.2525710828796128 | 0.2756357609182377 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.294279148201433 | 1.314532766058348 | 1.344099753223844 | 0.9306610227090208 | 2.128248799380721 | 0.924 | 0.931
2001 Acura Integra GS Sedan 4D | [NAME] | 2001 | Acura | Integra | GS Sedan 4D | 0.2433558765795606 | 0.2756357609182377 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.247056603068596 | 1.314532766058348 | 1.344099753223844 | 0.9306610227090208 | 2.050598375109943 | 0.897 | 0.921
2001 Acura Integra GS-R Sport Coupe 2D | [NAME] | 2001 | Acura | Integra | GS-R Sport Coupe 2D | 0.2563613819447654 | 0.2756357609182377 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.313702215123994 | 1.314532766058348 | 1.344099753223844 | 0.9306610227090208 | 2.160187132711421 | 0.932 | 0.935
2001 Acura Integra GS-R Sedan 4D | [NAME] | 2001 | Acura | Integra | GS-R Sedan 4D | 0.24774620693849 | 0.2756357609182377 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.269554479597029 | 1.314532766058348 | 1.344099753223844 | 0.9306610227090208 | 2.087592773711503 | 0.912 | 0.925
2001 Acura Integra Type R Sport Coupe 2D | Sports Car | 2001 | Acura | Integra | Type R Sport Coupe 2D | 0.4314184981104988 | 0.2756357609182377 | 0.281835468689584 | 0.273355520526705 | 0.2096834464953939 | 1.578232249633137 | 1.314532766058348 | 1.344099753223844 | 1.303658086012573 | 3.635277206583239 | 0.989 | 0.992
2001 Acura NSX Sport Coupe 2D | Sports Car | 2001 | Acura | NSX | Sport Coupe 2D | 0.5166903941449474 | 0.506747450948483 | 0.281835468689584 | 0.273355520526705 | 0.2096834464953939 | 1.890177279571239 | 2.416726066926864 | 1.344099753223844 | 1.303658086012573 | 8.004333386516652 | 0.997 | 0.999
2001 Acura NSX T-Targa 2D | Sports Car | 2001 | Acura | NSX | T-Targa 2D | 0.4968045077520188 | 0.506747450948483 | 0.281835468689584 | 0.273355520526705 | 0.2096834464953939 | 1.817429941765103 | 2.416726066926864 | 1.344099753223844 | 1.303658086012573 | 7.696270248167031 | 0.996 | 0.999
2001 Acura CL 3.2 Coupe 2D | [NAME] | 2001 | Acura | CL | 3.2 Coupe 2D | 0.1959043779512028 | 0.2058432245814934 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.003895412462837 | 0.9816856219311291 | 1.344099753223844 | 0.9306610227090208 | 1.232775306976314 | 0.55 | 0.672
2001 Acura TL 3.2 Sedan 4D | [NAME] | 2001 | Acura | TL | 3.2 Sedan 4D | 0.2135721667240785 | 0.2135721667240785 | 0.281835468689584 | 0.1951442107605555 | 0.2096834464953939 | 1.094432501439329 | 1.018545671075518 | 1.344099753223844 | 0.9306610227090208 | 1.394416509299729 | 0.727 | 0.746
2001 Acura MDX Sport Utility 4D | Luxury Crossover | 2001 | Acura | MDX | Sport Utility 4D | 0.229907624153641 | 0.2354887943924225 | 0.281835468689584 | 0.2372091849451626 | 0.2096834464953939 | 0.9692188951569919 | 1.123068121629694 | 1.344099753223844 | 1.13127282534615 | 1.655109869672727 | 0.473 | 0.841
2001 Acura MDX Touring Sport Utility 4D | Luxury Crossover | 2001 | Acura | MDX | Touring Sport Utility 4D | 0.2410699646312043 | 0.2354887943924225 | 0.281835468689584 | 0.2372091849451626 | 0.2096834464953939 | 1.016275843985275 | 1.123068121629694 | 1.344099753223844 | 1.13127282534615 | 1.735467795866231 | 0.576 | 0.86