Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Pivot tables and grouping words that are both upper and lower case

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?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dq dq is offline
external usenet poster
 
Posts: 46
Default Pivot tables and grouping words that are both upper and lower case

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

Reply
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
Changing file in all upper case to upper and lower case Sagit Excel Discussion (Misc queries) 15 May 30th 07 06:08 AM
Change from mixed caps and upper lower to all upper lower case Fish''s Mermaid Excel Worksheet Functions 3 October 13th 06 02:15 PM
Change the text from lower case to upper case in an Excel work boo dave01968 Excel Discussion (Misc queries) 2 December 9th 05 10:09 AM
How do I convert all upper case excel sheet into upper and lower . DebDay Excel Discussion (Misc queries) 1 March 9th 05 09:31 PM
How do I change existing text from lower case to upper case CT Cameron Excel Discussion (Misc queries) 2 November 30th 04 02:07 AM


All times are GMT +1. The time now is 07:41 PM.

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

About Us

"It's about Microsoft Excel"