Hiding Rows with False

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I've got a bunch of rows of data that I want to copy and put somewhere
else, but many of the rows have "false" in them. They don't show
anything and just look blank, but they leave the row blank and take up
a lot of space. It looks something like this:

tom 47


Mary 36
Bob 18



Dan 29





Ed 44

Is there a way to truncate the list by hiding the rows that return a
false value and just making a normal list like the following?

tom 47
mary 36
bob 18
dan 29
ed 44
 
You can apply Autofilter to one of the columns and just select Non-
blanks from the filter pull-down (or, if the cells contain FALSE and
that is hidden by conditional formatting {white on white to look
blank} then choose Custom | Does Not Equal | FALSE).

Hope this helps.

Pete
 
Thanks, autofilter did the trick.

You can apply Autofilter to one of the columns and just select Non-
blanks from the filter pull-down (or, if the cells contain FALSE and
that is hidden by conditional formatting {white on white to look
blank} then choose Custom | Does Not Equal | FALSE).

Hope this helps.

Pete
Click to expand...
 
You're welcome, Jim - thanks for feeding back.

I use this approach all the time, but one drawback is that it is not
automatic/dynamic, i.e. if the values change then you have to manually
re-apply the same filter.

Pete
 
Back
Top