Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
HI, we have the following data, and want to filter the data on behalf of the following points. (we have excel 2007 and 2010)
(1) Order Not Received and target date is passed
(2) Order Received but balance Qty difference is 50 or more than 50
Help please
(1) Order Not Received and target date is passed
(2) Order Received but balance Qty difference is 50 or more than 50
New Microsoft Excel Worksheet - Copy.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Date | Order | P Name | TG | Qty | Recd. Date | Recd. Qty | ||||
2 | 27/4/2010 | Given | TEST 1 | 4/29/2010 | 500 | 4/27/2010 | 250 | 250 | |||
3 | 9/5/2010 | Given | TEST 2 | 5/16/2010 | 200 | 5/20/2010 | 160 | 40 | |||
4 | 9/5/2010 | Given | TEST 3 | 5/16/2010 | 150 | 5/17/2010 | 100 | 50 | |||
5 | 10/5/2010 | Given | TEST 4 | 5/17/2010 | 600 | 600 | |||||
6 | 10/5/2010 | Given | TEST 5 | 5/17/2010 | 254 | 5/16/2010 | 254 | ||||
7 | 12/5/2010 | Given | TEST 6 | 5/19/2010 | 654 | 5/18/2010 | 654 | ||||
8 | 12/5/2010 | Given | TEST 7 | 5/19/2010 | 951 | 6/10/2010 | 950 | 1 | |||
9 | 12/5/2010 | Given | TEST 8 | 5/19/2010 | 757 | 6/15/2010 | 757 | ||||
Sheet4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I8,I2:I5 | I2 | =E2-H2 |
Help please