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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>