Forum Discussion

lennox25's avatar
lennox25
Icon for Post Patron rankPost Patron
2 years ago
Solved

Identifying 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

 

 

Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    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.

     

3 Replies

  • audreygerred's avatar
    audreygerred
    Icon for Super User rankSuper User
    2 years ago

    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.