27 Dec 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.
Check the “My data has headers” box if applicable, then choose the columns to identify the duplicates and click OK.
Excel will remove the duplicates and leave the unique values.