Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi,
Thanks in advance,
we have the following sheet where we want to match some condition
now we want to check if
Sheet1!E2:E5 and Sheet1!H2:H5 is not blank and Sheet1!G2:G5 is blank then filter the value, as below given sheet but we need selected headings or columns
help pls
Thanks in advance,
we have the following sheet where we want to match some condition
Example (2).xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | O No | Date | desc | p/f | Date | Status | Track | Comment | fp | |||
2 | 658595 | 42206 | o is still pending | 5265 | 10-01-2015 | on rent | 359624/A5 | recd very good | o again | |||
3 | 3596246 | 42206 | o is sent to us | 265415 | 10-02-2016 | 3596246/A68 | recd order again | not | ||||
4 | 658947 | 42195 | o is pending due to stock | 2515 | 15-02-2010 | update soon | 658595/65 | best of luck | recd | |||
5 | 625478 | 42193 | O is in dispatch process | 215485 | 25-02-2011 | 359624/154A | great product | wait | ||||
Sheet1 |
now we want to check if
Sheet1!E2:E5 and Sheet1!H2:H5 is not blank and Sheet1!G2:G5 is blank then filter the value, as below given sheet but we need selected headings or columns
Example (2).xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | p/f | Status | Track | fp | ||
2 | 265415 | 3596246/A68 | not | |||
3 | 215485 | 359624/154A | wait | |||
Sheet2 |
help pls