+ Reply to Thread
Results 1 to 2 of 2

Group in Pivot by Case sensitive -how to do

  1. #1
    Forum Contributor
    Join Date
    09-30-2008
    Location
    London
    Posts
    124

    Group in Pivot by Case sensitive -how to do

    Dear all,

    I have a data below

    Branch Account code Account Name Months Sales
    AYLESBURY H01371 XYZ Limited 2013-06 100
    AYLESBURY H01371 XYZ Limited 2013-07 200
    AYLESBURY H01371 XYZ Limited 2013-08 150
    POOLE h01371 ABC Co. 2013-07 400
    POOLE h01371 ABC Co. 2013-08 500
    POOLE h01371 ABC Co. 2013-06 700

    when I use pivot table and group by branch,account code and Account name it give only two records but both have H01371.

    I want two record, one should be H01371 and second h01371.

    How to separate both upper & lower case?

    See attachment.


    Please help!

    Regards

    Vinay
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Group in Pivot by Case sensitive -how to do

    Hi, pivot table is not case sensitive.

    You could use an helper column in order to distinguish the different accounts.

    =IF(CODE(LEFT(B2))>90,B2&" ",B2)

    B2&"space" if "h"

    I'm sure you 'll get better solutions.

    Regards
    Last edited by canapone; 10-09-2013 at 10:47 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] SUMPRODUCT Or SUMIF - In case of Case sensitive???
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-28-2012, 07:57 AM
  2. Case sensitive on Pivot Table
    By belkaw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-27-2011, 08:42 AM
  3. How do I make a Pivot Case sensitive?
    By Green Chameleon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2006, 09:20 AM
  4. [SOLVED] .Name case sensitive
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 05:00 PM
  5. Case Sensitive
    By hemants in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2005, 04:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1