Locate highest and lowest showing values in numbers and text

[Caly]

Hello I have a table showing items in rows and sizes in column headers along with a breakout for quantities and sales. I’m trying to show a summary where a formula will have a summary to show the highest seller, second, third and so on all the way to the lowest.

Is there a max or min formula for this or an index match? I’m confused and stumped with this to do a formula. Thank you to all in advance.

Below is the data

Type	Qty S	Qty M	Qty L	Sales S	Sales M	Sales L
Blue	60	5	77	4.56	11.12	23.45
Yellow	3	0	4356	3.25	10.98	16.55

 

[Caly]

Apologies I just am not sure what the expression is referring to for the “t” portion of the formula

 

[Peter_SSs]

The t is a variable that holds the result of the red calculation below. That result is then substituted twice in place of the blue 't's in the final calculation on the right.

=LET(t,TEXTSPLIT(TEXTJOIN("|",,TOCOL(A2:A3&" "&B2:D3&" "&B1:D1&" "&E2:G3))," ","|"),CHOOSECOLS(SORT(IFERROR(t+0,t),2,-1),1,4,2,5))

More information on the LET function here: LET function - Microsoft Support