I'm trying to delete rows using a logic statement. If a particular cell in Row G is equal to 0, or has no number at all, then I would like to delete that entire row and shift all other cells up. Is there any statement I can use to do this?
Any help would be greatly appreciated!! Thanks so much!!
~Breanna
I already have in Row G the following loigc statement: =IF(ISTEXT(E1)=TRUE,"",IF(C1<10,"",E1)) so it would need to be an extension of this or a conditional format.
Again, thank you so much! I really hope there's an answer out there!
There is no way to delete rows, columns or cells using statements alone. You can
...A Use a macro/VBA or
...B Filter on the Column G with 0 or blank criteria, then delete those rows manually. This would be the quickest way to do it IMO
Last edited by ChemistB; 06-16-2009 at 11:06 AM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks