Sort value of contiguous columns in Increasing/Decreasing order

[hsandeep]

My input range is E6:J7. E7:J7 which generates numerical values EXCEPT 0 or “” (null). ALSO they are contiguous columns. E6:J6 contains headers
IF B3=1, M7:R7 should get values from E7:J7 in INCREASING order. ALSO M6:R6 headers should be ‘corresponding’.
IF B3=2, M7:R7 should get values from E7:J7 in DECREASING order. ALSO M6:R6 headers should be ‘corresponding’.

How to achieve this?
Thanks in advance.

Book2.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
3	1
4
5
6				AA	CC	BB	DD	EEE	ABC			ABC	BB	EEE	AA	CC	DD
7				44	55	11	77	20	2			2	11	20	44	55	77
8												DD	CC	AA	EEE	BB	ABC
9												77	55	44	20	11	2
Sheet1

 

[hsandeep]

There are two ranges: AQ7:AX7 contains numbers and AQ8:AX8 contains corresponding header.
Working with AQ7:AX7 to get ranking and its corresponding position, then its header.
For example, in my sample in #16:
55 is found twice in AQ7:AX7. Both are 2nd ranking. But it required 1st 55 is 2nd then 2nd 55 is 3rd ranking.
Using a tip to get difference: Try to make a very small difference amount between them.
1st 55 is in column(AR) (column index = 44) , 2nd 55 is in column(AW) (column index = 49)
Try to add "column Index *10^-2" into 55 to make them small difference
AR7 = 55 + column()*10^-2 = 55 + column()/100 = 55.44
AW7 = 55 + column()*10^-2 = 55 + column()/100 = 55.49
Using this algorhym, then this array statement:

establish an array of values where dupplicate amounts are differrent
={44.43,55.44,11.45,77.46,11.47,2.48,55.49,8.5} (testing by Highlight that statement in formula bar then hit F9 to see instantly)
Then using AGGREGATE (or small, large) to get the rank.

Fantastic & intelligently usage of micro mathematics..I understood use of 10^-2
Lastly why A7 & A8 in the 2 formulas?
If A7 or A8 has a value, will it change the formula's final results?

 

[bebo021999]

Its INDEX(range, index) construction
=INDEX($A8:$AX8,index)
If index = column(AQ7) = 43 then
=INDEX($A8:$AX8,43)= AQ8

 

[hsandeep]

Its INDEX(range, index) construction
=INDEX($A8:$AX8,index)
If index = column(AQ7) = 43 then
=INDEX($A8:$AX8,43)= AQ8

Understood construction of the formula...it requires in depth vision of the scenarios vis a vis the final outcome that has to be achieved..Many thanks bebo021999