How do I distinguish between upper and lower case with pivot tabl.

F

Fielding

How do I distinguish between upper and lower case items when creating a pivot
table, e.g. a list of warehosue names which have combinations of both upper
and lower case, lower case being one type of warehouse and the upper case
ones representing a different type
 
J

Jason Morin

What you could do is add a column to the original table
that attaches a "1" in front of every warehouse name whose
first character is upper case.

=IF(CODE(LEFT(A2))<91,1&A2,A2)

And fill down. Then use this new column in your pivot
table.

HTH
Jason
Atlanta, GA
 
Top