excel 2010
I am familliar with using find&select, and then using "go to special", and selecting blanks
The problem is that the rows I need to delete are formatted where the blanks are the result of =IF([xxx], [xxx],"")
and so under the "go to special", these rows are not counted as blank. So how do I remove them in mass from my spreadsheet?
Any help appreciated.
Is there a specific column which would represent the row (i.e. if Col D has "" then the row is "blank")?
If so, then you can filter on that column and delete visible rows.
Alternately, you can create a dummy column to filter on.
=COUNTIF(A2:F2, "") and filter on 6
Either of those ideas work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I suppose any colum could be that, if the row is blank, then any colum in that row will be blank (or farmatted to = "")
but how would I filter on that colum without edleting the formatting fot that column (which pouplates on the non-blank rows)
I suppose any colum could be that, if the row is blank, then any colum in that row will be blank (or farmatted to = "")
but how would I filter on that colum without edleting the formatting fot that column (which pouplates on the non-blank rows)
Select your range (from any cell inside your range CNTRL SHIFT 8) then select "Filter" The Filter considers "" as blanks. Then select those rows, right click> Delete Rows. I'm not sure I understand your question. The formulas in the other rows should adjust
I dont have a problem selecting and deleting single rows. My issue is that I've got an 800 row spreadsheet, and am trying to avoid manually selecting 100+ rows to delete.
When I try to use the Find&Select function, special option, it does not register/highlight my empty rows as blank, I'm guessing because they are populated with a formula, though no data, because the formula resulted in blank rows (which I'm trying to remove)
Once you've filtered, you can select the remaining rows and delete them all at once.
You are correct, you cannot use the Find & Select method.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks