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