Sachin Singh
asked on
Conditionally deleting of rows
If column E is not greater than 1% of column D and Column K is lower than Column D then keep all this type of row and delete rest row
If column E is not lower than 1% of column D and Column K is greater than Column D then keep all this type of row and delete rest row
Book1.xlsm
If column E is not lower than 1% of column D and Column K is greater than Column D then keep all this type of row and delete rest row
Book1.xlsm
The easiest way would be to add a helper column then use AutoFilter. The helper column could be added with VBA and deleted if you want, or simply added and hidden. I'm off out for about an hour but I'll check back
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thnx Neeraj Sir and Roy Cox Sir for ur great support
You're welcome Sachin! ☺️