Case sensitive problem in Excel’s pivot table-CodePudding

Good day.

Example below, the ID of people are case sensitive (if don’t consider the case, some of them are of the same, for example, David’s and Mike’s, Lilly’s and John’s).

When putting them into a pivot table, it displays the same IDs for different people, i.e. David’s = Mike’s, Lilly’s = John’s.

Is there a way to have the pivot table to display actual IDs (case sensitive)?

Thank you.

ID  Name
Txze    David
TxZe    Mike
TwgQ    Lucy
3RqM    Lilly
3RQm    John
TvrE    Kate

CodePudding user response：

So, had a quick go with index() and match() as suggested in my comment:

INDEX(A$2:A$7,MATCH(D2,$B$2:$B$7,0))

D2 and D4 contain the Name looked for and the results are in F2 & F4, which give the different results. Note, 0 is used for an exact match in the match function.