Forum Discussion

83dons's avatar
83dons
Helper III
1 year ago
Solved

Identifying duplicates

Hi I have a simple table with two columns and I want to identify all the roles where there are duplicate NI Numbers (ie NI Number > 1). I guess there could be more than 2 duplicates for the same NI N...
Need Help
  • Demert's avatar
    Demert
    1 year ago

    Hi 83dons  if you have access to edit these table in Power Query, you have a nice option to only keep duplicates. 

     

    Select the column where you want to keep the duplicates from then select keep rows and click on keep duplicates.

     

Demert's avatar
Demert
Resolver III
1 year ago

Hi 83dons  if you have access to edit these table in Power Query, you have a nice option to only keep duplicates. 

 

Select the column where you want to keep the duplicates from then select keep rows and click on keep duplicates.

 

  • 83dons's avatar
    83dons
    Helper III
    1 year ago

    Perfect thanks! Very easy!