Best Practices

Hi everyone.

I hope you are well.

I want to find duplicates in a table and show them side by side in another table. In the table want to check for phone number as a duplicate. Could you please help me.

I have attached the table as a sample and the ideal result.

Thanks,

table.xlsx

ideal.xlsx

Best Practices

Accepted answers

Luke_C

@Simon1187 happy to help! If it's all set please mark my response as the solution. This helps people in the future find it in search results easier

All comments

Luke_C

Hi @Simon1187

Here's how I'd approach this:

Transpose data to get all phone numbers in one column
Remove null values
Unique tool to remove duplicates
Join Unique/duplicate records on phone number
The J output will show you which contact IDs have the same phone number
The L output will show you contacts that did not have a duplicate.

New Workflow3.yxmd

Simon1187

Hi @Luke_C

Thank you very much. I really appreciate your help.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703