• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF and condition not met then go to next row, when condition met below rows should highlight ?

Hi Can you help me to solve get below logic in excel?

Item CodeItem DescriptionItem GroupQty On HandResult
0150133Service lathe machineSP-Electric
88.00
132.00
GRV014039
02/28/2018​
IF 88=<132 (KEEP THE ROW AS IT IS)
019CHA-1502106OIL SEAL-DIFFERENTIALSP-CHERY
8.00
8.00
GRV017289
03/27/2019​
IF 8=<8 (KEEP THE ROW AS IT IS)
0320138M8X1.25(6H) GR-10,FLNG CLEVELOC NUTSP-Electric
44.00
66.00
GRV014039
02/28/2018​
IF 44=<66 (KEEP ROW AS IT IS)
07631-001-0000MUNIVERSAL BEARING PULLERSP-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-0000ROTOR PULLERSP-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​
 

Attachments

  • Book1.xlsx
    9 KB · Views: 5
The arrangement of your data is horrible, so it's difficult to get a robust solution.
So test very carefully and check that pressing the button near cell F2 in the attached highlights the correct rows - this offering is not robust.
 

Attachments

  • Chandoo43583.xlsm
    19.3 KB · Views: 11
Back
Top