remove duplicates based on name found in column b

Dear All,

I have exported an excel from another system, sadly the system gives me a total of 15k duplicates.

As example :

set	user_name	update_time	sys_created_on
1122	Kumar Kumar	1:23	1:23
1122	Kumar Kumar	1:23	1:23
1122	Kumar Balis	1:26	1:26
1122	Kumar Balis	1:26	1:26

Now i would like to filter only the uniqe sets so it will give me ( in this case ) this :

set	user_name	update_time	sys_created_on
1122	Kumar Kumar	1:23	1:23
1122	Kumar Balis	1:26	1:26

Please help me as soon as possible, please keep in mind that i am a total noob ad excel.

Also posted http://www.ozgrid.com/forum/showthre...509#post766509

Under Data Tab, you should be able to click Remove duplicates. You choose the Column that sets the criteria.