Sharanga Jayatilake
New Member
Hi Can you help me to solve get below logic in excel?
Item Code | Item Description | Item Group | Qty On Hand | Result |
0150133 | Service lathe machine | SP-Electric | 88.00 | |
132.00 | GRV014039 | 02/28/2018 | IF 88=<132 (KEEP THE ROW AS IT IS) | |
019CHA-1502106 | OIL SEAL-DIFFERENTIAL | SP-CHERY | 8.00 | |
8.00 | GRV017289 | 03/27/2019 | IF 8=<8 (KEEP THE ROW AS IT IS) | |
0320138 | M8X1.25(6H) GR-10,FLNG CLEVELOC NUT | SP-Electric | 44.00 | |
66.00 | GRV014039 | 02/28/2018 | IF 44=<66 (KEEP ROW AS IT IS) | |
07631-001-0000M | UNIVERSAL BEARING PULLER | SP-2Wheelers | 23.00 | |
4.00 | Annual Inventory Ver | 03/25/2019 | IF 23 =<4 (SINCE condition not met go to next row and add 4 + 20 and check the condition) | |
20.00 | GRV010507 | 06/01/2017 | IF 23 =< 24 (Condition met, keep these 2 rows as it is) | |
07733-001-0000 | ROTOR PULLER | SP-2Wheelers | 2.00 | |
5.00 | GRV016109 | 11/07/2018 | IF 2 = < 5 (CONDITION MET KEEP THIS ROW AND BELOW 4 ROWS SHOULD GET HIGHLIGHTED TO REMOVE LATER) | |
1.00 | Stock Count 2018 | 03/31/2018 | ||
1.00 | GRV012653 | 10/03/2017 | ||
5.00 | GRV012524 | 09/27/2017 | ||
2.00 | GRV010504 | 06/01/2017 |