How to find two or more maximum values?

Question

Google Sheets

Tell me, how can I find in a range of cells, say, A1: Z1, two or more maximum numbers? Something like the MAX() function.

Answer 1

Let's say in the range A2:A11 you have numbers from zero to nine.
The formula =ArrayFormula(LARGE(A2:A11;{1;2;3}))will display the three largest values ​​in the column:

9
8
7

To display in one cell separated by commas:=ArrayFormula(JOIN(", ";LARGE(A2:A11;{1;2;3})))