[RESOLVED] Remove duplicates in Excel

Hi all,

I have a excel with 1000 cells of some sort of text let say Name. I want to remove duplicates. How can I do that?

If I run a macro on it, it should remove all duplicate Names. All the names should come only once.

Thanks,

CS.

Hi Raman,

Use following link to see the way to remove duplicate rows from your list.

http://office.microsoft.com/en-us/as...346261033.aspx

And furthure, I suggest you to look for help on your own (In the Help provided) first then look for Help in the forums, This way we can use forums better.

Regards,

Alankar

Quote:

---

Originally Posted by cssriraman

Hi all,

I have a excel with 1000 cells of some sort of text let say Name. I want to remove duplicates. How can I do that?

If I run a macro on it, it should remove all duplicate Names. All the names should come only once.

Thanks,

CS.

---