Hi, I want to delete all the rows that contain the word true or false. How can I do this? Thanks
D Diana Dec 18, 2009 #1 Hi, I want to delete all the rows that contain the word true or false. How can I do this? Thanks
J Jordon Dec 18, 2009 #2 Diana said: Hi, I want to delete all the rows that contain the word true or false. How can I do this? Click to expand... Can you sort on the column containing true or false, then select all the rows in one group and delete them? Or does it need to be automatic?
Diana said: Hi, I want to delete all the rows that contain the word true or false. How can I do this? Click to expand... Can you sort on the column containing true or false, then select all the rows in one group and delete them? Or does it need to be automatic?
D Dave Peterson Dec 18, 2009 #3 If the data is in one column, you could apply data|filter|autofilter (in xl2003 menus) to that column. Show the rows that contain either True or False and delete the visible rows. Then remove the autofilter.
If the data is in one column, you could apply data|filter|autofilter (in xl2003 menus) to that column. Show the rows that contain either True or False and delete the visible rows. Then remove the autofilter.
