Display only nonzero items in a table???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lovebaby - 04 Jul 2006 12:16 GMT

If I have a table with 5 columns and I want to only display rows with
nonzero entries of one of the columns...

What is the best way to do this?

I want to be able to integrate this into a macro, also.

Thanks

Reply to this Message

Dave Peterson - 04 Jul 2006 13:03 GMT

I'd select the range (include one row of headers) and use
data|filter|autofilter

Then filter to show the not equal to 0 cells/rows.

You could record a macro if you want the code.

> If I have a table with 5 columns and I want to only display rows with
> nonzero entries of one of the columns...
[quoted text clipped - 4 lines]
>
> Thanks

Signature

Dave Peterson

Reply to this Message

Ben Woerdeman - 04 Jul 2006 15:17 GMT

Tools>options>view>
disable zero values and the zero will not schown anymore

Reply to this Message

Dave Peterson - 04 Jul 2006 15:41 GMT

That'll make the cells with 0's look blank, but it won't hide the rows.

> Tools>options>view>
> disable zero values and the zero will not schown anymore.
[quoted text clipped - 4 lines]
> Ben Woerdeman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36020
> View this thread: http://www.excelforum.com/showthread.php?threadid=558125

Signature

Dave Peterson

Reply to this Message

Rate this thread: