Re: my pivot table does not count all intances of a text string

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You're welcome. Thanks for reporting how you solved the problem.

Charlie wrote:
Thanks Debra. I found that the columnn at the head of the row whose status i was counting in the status row was blank. I have fixed the problem and now get the correct results

"Debra Dalgleish" wrote:


Are the rows at the end of the source table? Maybe they aren't included in the pivot table source range.

If that's the problem, you could use a dynamic range as the source, and it will automatically expand to include new rows. There are instructions here:

http://www.contextures.com/xlPivot01.html

Charlie wrote:

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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.

Relevant Pages

  • Re: BOIDS of a Feather.....
    ... Charlie INITIATES a deliberately insulting string. ... REG wrote: ... Don Paulo, who constantly defend you, as friends do. ... ANY ONE OF THESE STRINGS, seen one of them say "Great joke, Charles," ...
    (rec.music.opera)
  • Re: BOIDS of a Feather.....
    ... Charlie INITIATES a deliberately insulting string. ... REG wrote: ... Don Paulo, who constantly defend you, as friends do. ... ANY ONE OF THESE STRINGS, seen one of them say "Great joke, Charles," ...
    (rec.music.opera)
  • Re: Like Someone (lowered Tuning)
    ... If Grant didn't have to cut his strings off I don't either:) ... Charlie ... > oh..yeah..I dunno when your birthday comes around but a wirecutters is in ... its a little cheap camera. ...
    (rec.music.makers.guitar.jazz)
  • Re: StringItUp! guitar strings
    ... for them to put it under strings), ... artist-relations connection for Thomastik strings. ... Charlie's Mom built guitars at Subway in the early 70's when Charlie ... Charlie taught guitar at our music ...
    (rec.music.makers.guitar.jazz)
  • Re: CASE...ENCASE Query...
    ... existing strings to see if you already have an identical one that you ... Interning strings is a expense; it can be sped up greatly by ... You'd want a fast, correct, compiler ... reporting, so that the user has the greatest amount of information to ...
    (comp.sys.acorn.programmer)