How to find the biggest numbers?

Hi everyone!

I want to create a formula that values if the number in the cell is in the biggest 25 numbers in the column and also check in another column the same thing.If the number is within the 25 biggest from the first column or the second then to give me the number of the cell. I created a formula but it is very large in order to apply for the 1st to the 25th biggest number. The formula is: IF(AND(or(K16=LARGE($K$16:$K$152,1),I16=LARGE($I$16:$I$152,1)),K16<>0),K16,"") but only for the 1st biggest number of the columns. Can anyone suggest somethin lighter?? Thank you!

I would suggest instead of I16=LARGE($K$16:$K$152,1) try I16>=LARGE($K$16:$K$152,25)