View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default Pivottable won't count blank values

hI eric,

what sort of values do you count <i.e. TEXT or NUMBERS

--
*****
birds of the same feather flock together..



"Eric" wrote:

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.