Removing Duplicate Rows

[virtualized]

Hi Everyone


I have data in following form:


(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

 

[robg]

If you have excel 2007 or 2010 there is a button on the ribbon to do just that. Check on the Data tab.

 

[Faseeh]

Hi virtualized,


If you want to "delete" duplicates then robg is absolutely right. But if you want something like list of unique/duplicate values then have a look at this post:


http://chandoo.org/wp/2008/11/06/unique-duplicate-missing-items-excel-help/


..and download the sample file.


Thanks,

FASEEH

 

[virtualized]

Hi

Can you please tell me how can i upload my Excel file on this Forum? I think that will clarify my question and would make it easy to get help from you.


Best Regards

 

[NARAYANK991]

Hi ,


You can use any file sharing website , Skydrive , GoogleDocs , Rapidshare , or any other of your choice , to upload the file.


Please ensure that you have given access rights for others , and post the access link here.


Narayan

 

[virtualized]

Hi

Thank You.


Link to the file is:

https://docs.google.com/open?id=0BwqQW589JCh7YTZmNWViOGYtMDYxMS00YmVhLTlkZjYtNWI3MjdiYTQ0ZjM3


Data is in 3 columns:

Column A is titled MyData, where Columns B and C are untitled, It looks like this:

MyData

(5,1) 5

(7,1) 6

(5,1) Duplicate 5

(19,1) 7

(7,1) Duplicate 6

(33,1) 8

(41,1) 100

(33,1) Duplicate 5


Final or required Output without Duplicate rows is:

MyData

(5,1) 5

(7,1) 6

(19,1) 7

(33,1) 8

(41,1) 100


Best Regards

 

[NARAYANK991]

Hi ,


If you have Excel 2007 , just select the "Remove Duplicates" feature ; select the entire range A2:C9 ; when Excel prompts you to select the column which has duplicates , select column A , and deselect columns B and C.


You should get the result you have shown.


Narayan

 

[virtualized]

Hi


Thanks a lot, it was a great help.


Best Regards

 

[NARAYANK991]

Hi ,


Happy to help. Keep visiting.


Narayan