I have an excel sheet having more than 30000 rows.
I want to delete entire rows if value in column B is either blank or zero or "Min".
The first row contains headers.
The sample excel file is attached herewith.
I have an excel sheet having more than 30000 rows.
I want to delete entire rows if value in column B is either blank or zero or "Min".
The first row contains headers.
The sample excel file is attached herewith.
Hi, try
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
You can use a filter
Or a reverse loopPlease Login or Register to view this content.
Please Login or Register to view this content.
The macro works like a charm.
thanks a lot.
Thank you boss. you saved lot of my work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks