View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Oldersox Oldersox is offline
external usenet poster
 
Posts: 24
Default Exlude Zero Values from Average

In the dropdown filter for the 'Target' column, just untick the '0' and the
table will recalculate without the zero's (but it will also not display them)

If you need the '0' items to display then unfortunately I do not know the
answer. Someone else maybe able to help here.