One suggestion is as follows...
(a) Sort the list by NAME, then by DATE VIEWED (ascending)
(b) Add an additional column (column D presumably), calling it say "First Viewed" in D1, with the formula in D2...
=(A2<>A1)Copy this formula down the column. It will show True when the name is different to the previous row, or False if it is the same.(c) You can now filter the list based on column D True values.
(d) The filtered list of rows can be copied and pasted to a fresh worksheet.
Bookmarks