How to always return the numbers of the first cell of a column Based on their value?

[Goldenrules]

Good day great minds, I have been battling with this fommula for while now and I need yours help on it.

In the first image is a list of 1 - 49 numbers with the trands of each numbers.

And on the second image is the lists of the highest 10 numbers trends and lowest 20 numbers trends.

I used this formula "=LARGE($CM4:$EI4,1) for the largest 10 number which worked perfectly will, including the lowest 20 too.

But instead of it given me those values for me, I want it to return the numbers.

I was able to come up with this formula "=INDEX($BZ$1:$DV$1,1,MATCH(MAX($BZ5:$DV5),$BZ5:$DV5,0))" but it's not working well.

Please kindly help.

 

[Goldenrules]

Note that while there are many similarities between Excel and Google Sheets, they are NOT the same, and there actually are differences.
As such, if you are posting a question about Google Sheets, pleasing clearly state you are doing so in your original title/question post, and post it to the appropriate forum, "General Discussion & Other Applications".

View attachment 88633

I have moved this thread for you to that forum.

Clearly understood, am really grateful.
Cheers.