hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
Range D5:D17 generates numerical values. It does not generates zero or ‘’(null). D5:D17 is a non contiguous column.
Other input cells are C2; F2, G2 & H2
Output range G5:G17 to be filled with values from D meeting below criteria’s
Find the cell in D5:D17 which is ‘nearest lower value’ of C2 in multiplication of F2.
Fill corresponding row of G with $G$2.
Output range H5:H17 to be filled with values from D meeting below criteria’s
Find the cell in D5:D17 which is ‘nearest higher value’ of C2 in multiplication of F2.
Fill corresponding row of H with $H$2.
How to accomplish?
Thanks in advance.
Other input cells are C2; F2, G2 & H2
Output range G5:G17 to be filled with values from D meeting below criteria’s
Find the cell in D5:D17 which is ‘nearest lower value’ of C2 in multiplication of F2.
Fill corresponding row of G with $G$2.
Output range H5:H17 to be filled with values from D meeting below criteria’s
Find the cell in D5:D17 which is ‘nearest higher value’ of C2 in multiplication of F2.
Fill corresponding row of H with $H$2.
How to accomplish?
Thanks in advance.
Book2.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
2 | 42229 | 100 | 1 | 2 | ||||
3 | ||||||||
4 | ||||||||
5 | 42100 | 0 | 0 | |||||
6 | 42200 | 1 | 0 | |||||
7 | ||||||||
8 | 42300 | 0 | 2 | |||||
9 | ||||||||
10 | 42600 | 0 | 0 | |||||
11 | 42800 | 0 | 0 | |||||
12 | ||||||||
13 | 43000 | 0 | 0 | |||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | 43500 | 0 | 0 | |||||
Sheet3 |