Increasing & Decreasing order of a range of integers

[hsandeep]

Input Range 1: C3:C17 is contiguous rows which generates positive integer values AND they are unique to each other AND >0
Input Range 2: E3:E17 is contiguous rows which generates positive integer values AND they are unique to each other AND >0

Output range 3: G3:G17: Values from Range 1 in INCREASING order of Range 2
Output range 4: I3:I17: Values from Range 1 in DECREASING order of Range 2

How to accomplish? Thanks in advance.

Referencing.xlsx
	C	D	E	F	G	H	I
2					Increasing		Decreasing
3	50		999		64		50
4	44		888		60		44
5	62		444		2		99
6	88		777		3		88
7	22		220		45		62
8	11		150		87		22
9	99		800		10		1
10	45		65		11		11
11	87		80		1		10
12	64		1		22		87
13	60		8		62		45
14	10		90		88		3
15	1		156		99		2
16	2		10		44		60
17	3		20		50		64
Sheet3

 

[hsandeep]

How about in K3

=SMALL(C3:C17,ROWS(K$3:K3))

and just change small to large for M3

What about K4=2nd smallest & K5=3rd smallest?

 

[Fluff]

Just drag the formulae down.