Removing Duplicate Rows

Hi, I have a file with 11,000 rows, many of which are duplicates.
File only has 2 columns.
Is there an easy way to remove all duplicate rows?

Thanks in advance for your kind help.

Matt

Yes, explore the Advanced filter (menu Data>Filter>Advanced Filter)

Regards,
KL


"bvinternet" <bvinternet.1sn26a_1122149106.903@excelforum-nospam.com> wrote
in message news:bvinternet.1sn26a_1122149106.903@excelforum-nospam.com...
>
> HI, I HAVE A FILE WITH 11,000 ROWS, MANY OF WHICH ARE DUPLICATES.
> FILE ONLY HAS 2 COLUMNS.
> IS THERE AN EASY WAY TO REMOVE ALL DUPLICATE ROWS?
>
> THANKS IN ADVANCE FOR YOUR KIND HELP.
>
> MATT
>
>
> --
> bvinternet
> ------------------------------------------------------------------------
> bvinternet's Profile:
> http://www.excelforum.com/member.php...o&userid=25525
> View this thread: http://www.excelforum.com/showthread...hreadid=389619
>