• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

10 largest values

Belleke

Well-Known Member
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
 

Attachments

  • GROOTSTE WAARDEN_EXCEL(1).xlsx
    8.7 KB · Views: 5
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))
 

Attachments

  • Belleke GROOTSTE WAARDEN_EXCEL(1) Chandoo SPILL 365 AliGW.xlsx
    9.8 KB · Views: 2
Back
Top