Hide rows using IF

  • Thread starter Thread starter Mike
  • Start date Start date
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.
 
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
 
Back
Top