hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
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.
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 |