Identifying duplicates/matches in same row from 2 columns

[lennox25]

Hi. 

I have a table. I need to be able to filter out the matches against non matches and conditionally format the 'True'

 Here is my table.

and this is the result I would like to acheive

[audreygerred · Accepted solution]

Hi! In Power Query, I would make a new custom column that is the difference of A and B, then create a conditional column that specifies if the new custom column = 0, True, else, False.

You could also skip adding the column that calculates 0 or not and just do a conditional column that looks to see if the value in one column is equal to another. You'll get the same TRUE/FALSE this way as well, but you won't have the additional step of the other column.

[lennox25]

Excellent - Thank you so much!

[audreygerred]

You are very welcome!