Ian Grieve demonstrates one method to get unique records in Excel.
Find Unique Records in Microsoft Excel
Archived post from 2018. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.