Pivot Tables Case Sensitive Grouping

M

Mick Scott

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
 
G

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
 
D

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.
 
Top