Removing Duplicate Rows

Hi Everyone

I have data in following form(also attached in Excel File):

(5,1)
(7,1)
(5,1) Duplicate
(19,1)
(7,1) Duplicate
(33,1)
(41,1)
(33,1) Duplicate

I want to remove duplicate entries from the Data, so that the remaining Data should be:
(5,1)
(7,1)
(19,1)
(33,1)
(41,1)

Can anybody please explain how it should be done?

Best Regards

Please Login or Register  to view this content.

Originally Posted by virtualized

Hi Everyone

I have data in following form(also attached in Excel File):

(5,1)
(7,1)
(5,1) Duplicate
(19,1)
(7,1) Duplicate
(33,1)
(41,1)
(33,1) Duplicate

I want to remove duplicate entries from the Data, so that the remaining Data should be:
(5,1)
(7,1)
(19,1)
(33,1)
(41,1)

Can anybody please explain how it should be done?

Best Regards

Column A --> Data -->Remove Duplicate. OK
If you like code, you try thiscode

Please Login or Register  to view this content.

Hi

Thanks a lot.

Best Regards