Forum Discussion

mahmoud's avatar
mahmoud
Helper I
4 years ago

Find duplication in two columns

Hello everyone!  I have a table, as it is in this URL,  https://www.dropbox.com/scl/fi/8qmd0ks7wb3rw5ac5pgoe/Example-v2.xlsx?dl=0&rlkey=z94e594t283zlwi03rse998kp    I would to check:     - if th...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi mahmoud ,

Based on your sample, could you please show the finally expected result in an Excel? It will help to solve your problem faster.

Best Regards,
Community Support Team _ kalyj

mahmoud's avatar
mahmoud
Helper I
4 years ago

Hi v-yanjiang-msft 

Thanks for your follow and support again! 

 

Here is the new examplse: 

https://www.dropbox.com/scl/fi/8qmd0ks7wb3rw5ac5pgoe/Example-v2.xlsx?dl=0&rlkey=z94e594t283zlwi03rse998kp

 

I added an Index to know where is the duplication rows, 

And added a new value (green cells), so the duplication should not appear while there is note then appear again once I entered a new value.

 

I hope it is clear, thanks for your support and follow

Best Regards

Mahmoud