Dynamics GP Tip: Remove Duplicates in Excel

Reduce work by removing duplicates from Microsoft Dynamics GP in Excel.

To identify and remove duplicates from an Excel file prior to integrating to GP, click on the Data tab, then choose Remove Duplicates.

remove duplicates in excel

Check the “My data has headers” box if applicable, then choose the columns to identify the duplicates and click OK.

removing gp duplicates

Excel will remove the duplicates and leave the unique values.

removed duplicates

Find more Tips & Tricks for using Microsoft Dynamics GP here.

Success StorySee Client Success Stories


“Our Socius team, in my eyes, is considered an extension of our own department. Their knowledge and professionalism provide the support we need to succeed and continue to grow.”
-John Keller
LPK in Cincinnati, OH

eBookRead Top eBooks and Whitepapers