hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
Cell Q4 & R4 generates numerical values.
Range K3:P5 also generates numerical values.
In B4 I require the cell’s value from K4:P4 which is equal to Q4 provided Q4>0. Thereafter, in B3 I require the corresponding value from K3:P3 and in B5 I require the corresponding value from K5:P5
Similarly, In C4 I require the cell’s value from K4:P4 which is equal to R4 provided R4>0. Thereafter, in C3 I require the corresponding value from K3:P3 and in C5 I require the corresponding value from K5:P5
How to accomplish?
Thanks in advance
Range K3:P5 also generates numerical values.
In B4 I require the cell’s value from K4:P4 which is equal to Q4 provided Q4>0. Thereafter, in B3 I require the corresponding value from K3:P3 and in B5 I require the corresponding value from K5:P5
Similarly, In C4 I require the cell’s value from K4:P4 which is equal to R4 provided R4>0. Thereafter, in C3 I require the corresponding value from K3:P3 and in C5 I require the corresponding value from K5:P5
How to accomplish?
Thanks in advance