Google Sheets: Replace AGGREGA function with similar one

[Berna11]

Good morning I need to replace the AGGREGA function with a similar one
in the attached file TWS sheet column E find my formula with Aggrega that gives the correct result.

I would like to find an alternative formula without Aggrega that gives me the same result
Thank you

[AliGW]

Why do you not want to use the AGGREGATE function?

Try this:

=IFERROR(INDEX(CLS!$C$2:$C$1000,MATCH(SMALL(IF(FREQUENCY(CLS!$S$2:$S$1000,N(+CLS!$S$2:$S$1000)),CLS!$S$2:$S$1000),ROWS($1:1)),CLS!$S$2:$S$1000,0)),"")

[Berna11]

Hello
because it seems not recognized by google sheets

[AliGW]

OK - well, you need to say these things straight away! It's fundamental to the query, which is in the wrong place, so I am going to move it. I am not sure whether my suggestion will work - I do not use Google Sheets.

[Berna11]

ok, sorry for not having exposed the problem immediately.
For now, thank you
I do tests and I will let you know and if it works I will put the Solved.

[romperstomper]

In Sheets you could use something simpler like:

=INDEX(SORT(FILTER(CLS!C2:S20,CLS!S2:S20<>""),17,true),,1)