Pivot Tables Case Sensitive Grouping

[Guest]

Hi

I have a pivot table which is group items even if the text in the field is
not the same case - ie I have abc123 and ABC123 - The Pivot Table is grouping
it one the line rather than displaying two lines.

Anyone come across this before ??? I've looked for some options around this
but can't see to disable the case insensitive grouping.

Thanks

 

[GerryGerry]

You could create a function that returns a unique value for each text string
and use that as the grouping column of the pivot table. Post back here if
you want such a function

Gerry

 

[Dave Peterson]

That's pretty much the way excel compares strings--it ignores case in most cases
<bg>.

Depending on what you're doing, you could use another column and include that in
your pivottable:

=if(exact(a2,upper(a2)),"Upper",if(exact(a2,lower(a2)),"Lower","Mixed"))

But 123-#*&^*% will be marked as Upper.

 

[Eddie Schultz]

You can create a separate column in your data source and add the formula =A9&"_"&TEXT(CODE(A9). The results for a value of 'M' or 'm' in cell A9 will be be M_077 and m_109 respectively in the pivot table.