Hi Vass

If all the entries are repeated and are in adjucent rows you can do
this simple exercise.
Insert a new column and write 1in every odd row and 2 in every even row
till the last non blank row. Now put an auto filter, select 1 or 2 ,
this will show one set of entries. Select the visible cells and do CRTL
- (minus) or right click and select delete rows.. When prompted "Delete
Enrire Row?" click OK. Now remove the filters and you have only one set
of entries.

This can also be done using simple VBA code..

Thanks
Karthik Bhat
Bangalore