I have a spreadsheet with two columns, the first column has a name the second
a reference no. Some of the data is duplicated. How do I either merge the
data or delete the duplicated rows.
I tried search and find but that means I have to type in each surname. It is
a list of 600 rows.

Any ideas? Thanks
--
xxx888xxxx