How can I delete the entire row if the cell I am referring to is blank
Foreg: if A11 is blank, then it should delete the 11th row.
What formula shud I use along with isblank?
How can I delete the entire row if the cell I am referring to is blank
Foreg: if A11 is blank, then it should delete the 11th row.
What formula shud I use along with isblank?
Formulas cannot delete rows. You'll either need to use VBA or filter on blanks and then delete visible cells.
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
How can I make the sheet name to appear in a particular cell?
Try this
Copy and paste as is into any cell
=MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks