Is there a good aggregate equivalent for Google Sheets with the large funktion?

I try to write an easy randomizer based on a database for randomly combining data. This works fine in Excel, but not in GoogleSheets, because there is no aggregat

I've already tried LARGE and MAX but then its not randomizing, and with SUBTOTAL its not working. I thought it also could be based on ROW, but maybe i have a wrong concept.

The code in excel is like this (i use the german version of excel, but this should be the english equivalent)

=TEXTJOIN(" ";TRUE;INDIRECT("A"&ROUNDUP(RAND()*AGGREGAT(14;4;(A:A<>"")*ROW(A:A);1);0));INDIRECT("B"&ROUNDUP(RAND()*AGGREGAT(14;4;(B:B<>"")*ROW(B:B);1);0));INDIRECT("C"&ROUNDUP(RAND()*AGGREGAT(14;4;(C:C<>"")*ROW(C:C);1);0)))

As i mentioned there is no aggregat, and the other solutions i looked up didnt work for me.