hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
My input range is A5:A21 which generates numerical values EXCEPT 0 or “” (null). ALSO they are non-contiguous rows.
Output range is C5:C21
IF A4=1, the values of C5:C21 should be in INCREASING order
IF A4=2, the values of C5:C21 should be in DECREASING order
How to achieve this?
Thanks in advance.
Output range is C5:C21
IF A4=1, the values of C5:C21 should be in INCREASING order
IF A4=2, the values of C5:C21 should be in DECREASING order
How to achieve this?
Thanks in advance.
Book2.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
4 | 1 | 1 | 2 | ||||
5 | 42000 | 3200 | 42700 | ||||
6 | 42100 | 42000 | 42600 | ||||
7 | 42200 | 42100 | 42500 | ||||
8 | |||||||
9 | 42300 | 42200 | 42500 | ||||
10 | 42400 | 42300 | 42400 | ||||
11 | |||||||
12 | 42500 | 42400 | 42300 | ||||
13 | 42600 | 42500 | 42200 | ||||
14 | |||||||
15 | 42700 | 42500 | 42100 | ||||
16 | |||||||
17 | |||||||
18 | 3200 | 42600 | 42000 | ||||
19 | |||||||
20 | |||||||
21 | 42500 | 42700 | 3200 | ||||
Pr |