Remove duplicates and report unique IDs

For the first part, please see Help pages on

• Sort
• Advanced Filter (note option for Unique Values)

(You may want to add your Excel version to your profile so we can figure out how to give you more details on things like menu sequences to reach these.)

Once the list is sorted and unique, a quick and dirty way of converting to a list, assuming your list is in column A starting in A1, is to put this formula in B1:

=A1

and this formula in B2:

=A1&", "&A2

and then copy it down to the last row of your data. The last line will contain the complete list.