View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Pivottable won't count blank values

I'm doing a simple pivottable, showing a count of the different values in one
field of a table. The pivottable shows all the values, including "(blank)".
All the counts are shown, as expected, with the exception of the "(blank)"
value, which shows a blank instead of a count.

Any suggestions?

Thanks.