When Excel removes duplicates, it leaves the first line in place of each duplicate. So if you sort the table in a smart way so the hyperlinked data is on top, you remove the ones without hyperlinks. Make sure the filter arrows are visible (Select all data, click the filter icon on the Data tab). Then click the arrow on the column in question and choose Sort by color and sort by the color of the hyperlinks. Now have Excel remove duplicates.
perfect! Each duplicate information column also has a column with dates which change weekly so I just sorted them by date in one column (oldest date first), found and sorted by duplicates and ran the remove duplicates again. Thanks so much!