Weekly Dynamic: Find Duplicates in Excel

We’ve looked before at removing duplicates in Excel. But what if you just want to find duplicates to evaluate them?

Try this:

1) Export data from GP to Excel. You can export from SmartList or use a refreshable Excel report.

2) Highlight the information and pick Conditional Formatting | Highlight Cell Rules | Duplicate Values

3) Click OK to highlight duplicates in Red.

20140413-180031.jpg

4) You can filter the list by turning on filters and picking filter by color to only see duplicates without removing anything from the list.

20140413-180244.jpg

Copycat Attack: Fed up Microsoft Dynamics bloggers vent over content misuse | MSDynamicsWorld.com

MSDynamicsWorld looks at Copycat Attack: Fed up Microsoft Dynamics bloggers vent over content misuse

When this has happened to me it has mostly been inadvertent, but frankly, the Dynamics community is pretty small and I’m not afraid to publicly call out folks who truly steal content. Do you really want to buy financial software from someone that ethically challenged?