Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I have some 500 rows. I want to delete all rows, except row 1, of which col G is zero or blank while col A shows anything else than a string of which the first character is S or P. In other words, I want to keep row 1 and all rows in which col A shows text starting with S or P and all rows not having zero or blank in col G. I need the fastest code possible, my do loop takes a lot of time. I thank you in advance for your assistance. Jack Sons The Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
Want to delete rows | Excel Discussion (Misc queries) | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
How do I delete duplicate rows in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Delete specified critria rows | Excel Discussion (Misc queries) |