10 largest values

[Belleke]

In a worksheet, I have random unique digits in the range B4:G26.
Now I want to display in the range B28:G50 the 10 largest digits from the range B4:G26.
The other (smaller) digits should be converted to 0 or to an empty cell.
Colors are just for the example
Thanks

 

[AliGW]

If you have 2021 or 365:

=LET(l,LARGE(A1:C7,10),IF(A1:C7>=l,A1:C7,""))

or:

=LET(l,LARGE(A1:C7,10),IF(A1:C7>=l,A1:C7,0))

 

[Belleke]

Thanks.

 

[Peter Bartholomew]

My guess is that @AliGW 's solution may be marginally more efficient.

= IF(RANK(array, array) <= 10, array, "")

I prefer

= TAKE(SORT(array,,-1), 10)

but that presents the results as a separate array.