Create a helper column in E that is something like this
=OR(ISTEXT(B1),SUM(B1:D1))
You can then sort the table by column E, and delete the block of FALSE values.
Create a helper column in E that is something like this
=OR(ISTEXT(B1),SUM(B1:D1))
You can then sort the table by column E, and delete the block of FALSE values.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks