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!
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..❤
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😊
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
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!!
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?