LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 703
Default my pivot table does not count all intances of a text string

Hi, I am new to Pivot tables. I created a pivot table based on a 15 column
table in a worksheet. There are 4 types of text strings that are repeated in
one of the columns. My pivot table display the 4 string types and reports the
count of each type. But it does not count the text strings in 14 adjacent
rows. It counts the strings in all the oher rows, just not these 14. Tried
refreshing the data still did not work, retyped the strings does not work.

Your help is much appreciated


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Size PCStechnical Charts and Charting in Excel 0 October 12th 06 06:25 PM
Count only if another column has data in Pivot Table? [email protected] Excel Worksheet Functions 1 October 10th 06 09:16 PM
text in data area on pivot table jmb Excel Discussion (Misc queries) 0 September 28th 06 03:03 AM
Pivot table formats text data with 2 decimals Don S Excel Discussion (Misc queries) 3 October 6th 05 12:45 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"