Well, I'll hope I can pay up for this hectare space some day, but I'll go with this mega formula.

=INDEX(X,INDEX(SMALL(IF(ISTEXT(X),ROW(X)),ROW(INDIRECT("1:"&SUM(--ISTEXT(X))))),MATCH(MAX(SUMIF(OFFSET(X,SMALL(IF(ISTEXT(X),ROW(X)),ROW(INDIRECT("1:"&SUM(--ISTEXT(X))))),,IFERROR(SMALL(IF(ISTEXT(OFFSET(X,1,)),ROW(OFFSET(X,1,))),ROW(INDIRECT("1:"&SUM(--ISTEXT(X)))))-1,ROWS(X))-SMALL(IF(ISTEXT(X),ROW(X)),ROW(INDIRECT("1:"&SUM(--ISTEXT(X))))),),"<>0")),SUMIF(OFFSET(X,SMALL(IF(ISTEXT(X),ROW(X)),ROW(INDIRECT("1:"&SUM(--ISTEXT(X))))),,IFERROR(SMALL(IF(ISTEXT(OFFSET(X,1,)),ROW(OFFSET(X,1,))),ROW(INDIRECT("1:"&SUM(--ISTEXT(X)))))-1,ROWS(X))-SMALL(IF(ISTEXT(X),ROW(X)),ROW(INDIRECT("1:"&SUM(--ISTEXT(X))))),),"<>0"),)))