Hide rows using IF

M

Mike

I would like to hide some rows in my spread sheet. It looks something like
this:

Cat Redo Cod Redo Categories Incidents Share

J LR3 REMAKE 10 0.839%
E LR01 #N/A 0 0.000%

The formula in D12 (the first cell under the Incidents heading) is
=SUMIF(Detail!A:A,B22,Detail!E:E). I have a macro that updates these
numbers. I would like to have a row hidden if the D column has a 0 value or
is empty. Any help would be appreciated.
 
P

Pete_UK

Apply Autofilter to column D, select Custom... then Not Equal to then
0 (zero). You can set a second condition if you wish.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting rows when using filtering: how?? 6
Hide rows using VBA 2
hide rows 1
hide and unhide rows 5
Hide Row If 5
Using a function to hide rows 6
Hide Rows using a returtn value in a column 3
Hide rows if formula result is zero 3

Top