Pivot tables and grouping words that are both upper and lower case

G

Guest

I am having a problem with my pivot table. I am trying to count a series of
words that reoccur in both the upper and lower case. However, instead of
grouping them together as one total, it splits them into two groups. For
example:

Here 58
here 3
They 45
they 23

I would like the table to recognize that a word in both the upper and lower
case are the same word. Is there a way?
 
D

dq

Abdullah,

Excel groups the same name automatically regardless of caps. Perhaps
you've put the number fields not in the data area but in the row area.
Try removing them and if it is now grouped correctly.

DQ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I distinguish between upper and lower case with pivot tabl. 1
Replace words with proper upper/lower cases 1
How do I create an Index with both Capital & Lower cse words? 2
Counting Upper and Lower case chars in a Cell 7
Using COUNTIF and VLOOKUP with upper and lower case letters 5
Can I join on both lower case and upper case in the primary key? 2
Criteria that allows to Query Upper Case 6
Pivot table insertion changes upper and lower case letters 3

Top