I messed up my analysis today because of this method..blanks in cell also got del and data got misplaced...a day wasted.. but ultimately thanq for this knowledge..❤
Thank you, but it's still not working, as it's not allowing me to delete the rows when we have applied a filter, just like you selected the 0 ones and deselected the rest, any other ways?
This is what I was looking for....I have an Excel of some 70pages where I have to remove empty cells...doing it manually would take a lot of time....this made my work easy thank you😊
How did he select the entire dataset after applying the formula on the first row? When I try to do the same it’s stopping near the next black row. So not able to apply the formula to the entire dataset. Please help! Thanks so much!!
I was using "isblank" but it was returning wrong results as there seems some data in blank looking cells. Then your suggestion for "Counta" did the magic. Thanks
I have searched for this information for a long time and gave up. I then came across your video last week. Your instructions were easy and fast to implement! Now, I am more efficient in completing my deliverables. Huge thanks! I sincerely appreciate the content!