michellejames
New Member
- Joined
- Aug 16, 2013
- Messages
- 27
Hi there,
I have each mode and make for subset with different year. I need to find its max and min year. I thinking whether my I sort the data via make or mode or not? If i will not sort them then can I find each sku of each subset min and max year.
<tbody>
</tbody>
AS vio is important for us hence I can not short it. How to get the min and max year
<tbody>
</tbody>
Result
<tbody>
</tbody>
I have each mode and make for subset with different year. I need to find its max and min year. I thinking whether my I sort the data via make or mode or not? If i will not sort them then can I find each sku of each subset min and max year.
PG. | Min Year | Max Year | Make Name | Model Name | Engine Base Liter | VIO Summary |
100747900A00PG | 2012 | 2016 | Tesla | S | 88913 | |
26300-35503 | 2008 | 2018 | Hyundai | Sonata | 2.4 | 1553977 |
26300-35503 | 2011 | 2016 | Hyundai | Elantra | 1.8 | 885687 |
26300-35503 | 2008 | 2018 | Kia | Optima | 2.4 | 870002 |
26300-35503 | 2008 | 2019 | Hyundai | Elantra | 2.0 | 711328 |
26300-35503 | 2008 | 2018 | Hyundai | Accent | 1.6 | 536118 |
26300-35503 | 2010 | 2018 | Kia | Soul | 2.0 | 527408 |
26300-35503 | 2011 | 2018 | Kia | Sorento | 2.4 | 504615 |
26300-35503 | 2010 | 2018 | Kia | Soul | 1.6 | 437283 |
26300-35503 | 2010 | 2018 | Kia | Forte | 2.0 | 404992 |
26300-35503 | 2013 | 2018 | Hyundai | Santa Fe Sport | 2.4 | 376146 |
26300-35503 | 2011 | 2018 | Kia | Sportage | 2.4 | 371436 |
26300-35503 | 2008 | 2018 | Kia | Rio | 1.6 | 256063 |
26300-35503 | 2008 | 2018 | Hyundai | Tucson | 2.0 | 218675 |
26300-35503 | 2010 | 2015 | Hyundai | Tucson | 2.4 | 207645 |
26300-35503 | 2014 | 2016 | Kia | Forte | 1.8 | 167540 |
26300-35503 | 2012 | 2019 | Hyundai | Veloster | 1.6 | 161960 |
26300-35503 | 2011 | 2018 | Hyundai | Sonata | 2.0 | 150765 |
26300-35503 | 2016 | 2018 | Hyundai | Tucson | 1.6 | 119829 |
26300-35503 | 2013 | 2018 | Hyundai | Santa Fe Sport | 2.0 | 113938 |
26300-35503 | 2011 | 2018 | Kia | Optima | 2.0 | 107593 |
26300-35503 | 2010 | 2012 | Hyundai | Santa Fe | 2.4 | 96920 |
26300-35503 | 2008 | 2009 | Kia | Spectra | 2.0 | 81242 |
26300-35503 | 2014 | 2018 | Hyundai | Elantra GT | 2.0 | 74771 |
26300-35503 | 2008 | 2009 | Hyundai | Santa Fe | 2.7 | 72752 |
26300-35503 | 2007 | 2018 | Kia | Sportage | 2.0 | 72129 |
26300-35503 | 2007 | 2010 | Kia | Sportage | 2.7 | 57493 |
26300-35503 | 2013 | 2013 | Hyundai | Elantra GT | 1.8 | 40437 |
26300-35503 | 2017 | 2018 | Kia | Niro | 1.6 | 38560 |
26300-35503 | 2010 | 2014 | Hyundai | Genesis Coupe | 2.0 | 37514 |
26300-35503 | 2010 | 2015 | Kia | Forte Koup | 2.0 | 24728 |
26300-35503 | 2014 | 2016 | Kia | Forte5 | 2.0 | 23619 |
26300-35503 | 2016 | 2018 | Kia | Sorento | 2.0 | 23578 |
26300-35503 | 2008 | 2012 | Kia | Rondo | 2.4 | 21361 |
26300-35503 | 2010 | 2013 | Kia | Forte | 2.4 | 17167 |
26300-35503 | 2017 | 2018 | Hyundai | Ioniq | 1.6 | 16745 |
26300-35503 | 2010 | 2013 | Kia | Forte Koup | 2.4 | 16454 |
26300-35503 | 2013 | 2013 | Hyundai | Elantra Coupe | 1.8 | 15606 |
26300-35503 | 2008 | 2012 | Kia | Rondo | 2.7 | 14742 |
26300-35503 | 2008 | 2009 | Hyundai | Tucson | 2.7 | 13346 |
26300-35503 | 2008 | 2011 | Kia | Rio5 | 1.6 | 13026 |
26300-35503 | 2017 | 2018 | Hyundai | Elantra | 1.6 | 11740 |
26300-35503 | 2015 | 2018 | Hyundai | Sonata | 1.6 | 9335 |
26300-35503 | 2008 | 2009 | Kia | Spectra5 | 2.0 | 8710 |
26300-35503 | 2008 | 2008 | Hyundai | Tiburon | 2.0 | 8005 |
26300-35503 | 2008 | 2010 | Kia | Optima | 2.7 | 7532 |
26300-35503 | 2016 | 2018 | Kia | Optima | 1.6 | 7476 |
26300-35503 | 2008 | 2008 | Hyundai | Tiburon | 2.7 | 4758 |
26300-35503 | 2014 | 2014 | Hyundai | Elantra Coupe | 2.0 | 4194 |
26300-35503 | 2014 | 2016 | Kia | Forte Koup | 1.6 | 3676 |
26300-35503 | 2014 | 2016 | Kia | Forte5 | 1.6 | 3553 |
26300-35503 | 2018 | 2018 | Kia | Stinger | 2.0 | 2921 |
26300-35503 | 2018 | 2018 | Hyundai | Elantra GT | 1.6 | 1593 |
26300-35503 | 2019 | 2019 | Hyundai | Veloster | 2.0 | 29 |
26300-35503 | 2014 | 2016 | Kia | Rondo | 2.0 | 9 |
A44690 | 2004 | 2009 | Cadillac | SRX | 3.6 | 76973 |
A44690 | 2005 | 2011 | Cadillac | STS | 3.6 | 64275 |
A44690 | 2005 | 2010 | Cadillac | STS | 4.6 | 27912 |
A44690 | 2004 | 2009 | Cadillac | SRX | 4.6 | 21521 |
<tbody>
</tbody>
AS vio is important for us hence I can not short it. How to get the min and max year
PG. | Make Name | Model Name | Min Year | Max Year |
100747900A00PG | Tesla | S | ? | ? |
26300-35503 | Hyundai | Accent | ? | ? |
26300-35503 | Hyundai | Elantra | ? | ? |
26300-35503 | Hyundai | Elantra Coupe | ? | ? |
26300-35503 | Hyundai | Elantra GT | ? | ? |
26300-35503 | Hyundai | Genesis Coupe | ? | ? |
26300-35503 | Hyundai | Ioniq | ? | ? |
26300-35503 | Hyundai | Santa Fe | ? | ? |
26300-35503 | Hyundai | Santa Fe Sport | ? | ? |
26300-35503 | Hyundai | Sonata | ? | ? |
26300-35503 | Hyundai | Tiburon | ? | ? |
26300-35503 | Hyundai | Tucson | ? | ? |
26300-35503 | Hyundai | Veloster | ? | ? |
26300-35503 | Kia | Forte | ? | ? |
26300-35503 | Kia | Forte Koup | ? | ? |
26300-35503 | Kia | Forte5 | ? | ? |
26300-35503 | Kia | Niro | ? | ? |
26300-35503 | Kia | Optima | ? | ? |
26300-35503 | Kia | Rio | ? | ? |
26300-35503 | Kia | Rio5 | ? | ? |
26300-35503 | Kia | Rondo | ? | ? |
26300-35503 | Kia | Sorento | ? | ? |
26300-35503 | Kia | Soul | ? | ? |
26300-35503 | Kia | Spectra | ? | ? |
26300-35503 | Kia | Spectra5 | ? | ? |
26300-35503 | Kia | Sportage | ? | ? |
26300-35503 | Kia | Stinger | ? | ? |
A44690 | Cadillac | SRX | ? | ? |
A44690 | Cadillac | STS | ? | ? |
A44690 | Cadillac | SRX | ? | ? |
<tbody>
</tbody>
Result
PG. | Make Name | Model Name | Min Year | Max Year |
26300-35503 | Hyundai | Sonata | 2008 | 2018 |
26300-35503 | Hyundai | Elantra | 2008 | 2019 |
26300-35503 | Kia | Optima | 2008 | 2018 |
26300-35503 | Hyundai | Accent | 2008 | 2018 |
26300-35503 | Kia | Soul | 2010 | 2018 |
<tbody>
</tbody>