Excelpromax123
Board Regular
- Joined
- Sep 2, 2021
- Messages
- 172
- Office Version
- 2010
- Platform
- Windows
Hi everybody. I need to reduce data table B5:D1000 according to the following condition. If the row value of column C > 0 or the row value of column D is not a number, leave it as is and do nothing. The remaining case is reduced to the value of column D . Then output an area as the image describes. Thank you
Link File:
drive.google.com
Link File:
abc new --------.xlsm

Last edited: