I have a set of data that I use Power Query to then compare the contents of the cells and only display them if they don't match exactly.
The image below shows what I am getting out of Power Query. It is incorrectly showing names that are identical. I've tried trimming and cleaning the columns containing the text and you can see the conditional format on the output is picking up the ones that are actually different.
Any ideas?
Capture.JPG
I can't read that! Attach the workbook, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Waiting to see the workbook. It could be any number of things, but without seeing what you have done, there is no hope of diagnosing the problem.
Turned out I must not have cleaned and trimmed the text fields, because it now works as expected.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks