As a fun exercise (and cuz I had the data already in R and wanted to practice with dplyr) The list of teams that missed eliminations the prior year and then returned to finals in all of their events the next year (for unrelated reasons, I MAY have removed the win column and only have the level of competition they achieved) consists of 70 teams in the data set from 2007 to right before CMP 2016.
PHP Code:
"team" "year"
238 2016
1452 2016
2227 2016
2875 2016
3267 2016
3533 2016
3679 2016
4087 2016
4121 2016
4156 2016
4195 2016
4264 2016
4455 2016
4508 2016
4625 2016
4740 2016
4744 2016
601 2015
3527 2015
354 2014
2585 2014
2935 2014
3382 2014
3472 2014
3536 2014
145 2013
981 2013
1691 2013
1751 2013
2353 2013
2501 2013
3251 2013
4814 2013
167 2012
333 2012
922 2012
1769 2012
2034 2012
2084 2012
2151 2012
2389 2012
3676 2012
125 2011
540 2011
1006 2011
1541 2011
2165 2011
3802 2011
383 2010
847 2010
1329 2010
1546 2010
1937 2010
590 2009
743 2009
885 2009
1095 2009
1571 2009
61 2008
94 2008
702 2008
1111 2008
1164 2008
1652 2008
1677 2008
1803 2008
580 2007
623 2007
930 2007
2175 2007