• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there a way Pivot Table could distinguish 2 seemingly identical ID?

fred

Member
Hi,


Here is a question, in salesforce.com there are 2 project ID. They are independent projects but they have, in our eyes, same ID


ID number 1: 1234567890A

ID number 2: 1234567890a


the only difference is on the last letter "A" vs. "a". When I perform a pivot on this datatable they would be counted as one showing


Project ID Count

1234567890A 2


Is there a way to have pivot table to show them on 2 separate lines??
 
Fred

What about adding a space to the end of one eg "1234567890A" and "1234567890a "
 
Hi Hui,


There are thousands of projects and it'll be hard on the eyes to distinguish which projects have upper case letters at the end, versus those which have low case letters.


Thx. I think it's just salesforce.com being very dumb to assign project names this way.
 
Fred

Assumning you have a list of codes in Column A

You could use comething like the following in a helper column

=IF(CODE(RIGHT(A2,1))>95,A2&"_",A2)


This will add an underscore to anything in A2 that has its right character in lower case
 
Back
Top