Forum Discussion
lennox25
Post Patron
Post PatronIdentifying duplicates/matches in same row from 2 columns
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 ...
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.
lennox25Post Patron
Post PatronExcellent - Thank you so much!
audreygerred
Super User
Super UserYou are very welcome!